Database/docs/ru/api-query.md

Query API (RU)

Raw SQL через api.query() с биндингом параметров.

Execute

int rows = api.query().execute(
    "UPDATE players SET level = level + 1 WHERE id = ?",
    java.util.Collections.singletonList(1)
);

Query

List<String> names = api.query().query(
    "SELECT name FROM players WHERE level >= ?",
    java.util.Collections.singletonList(10),
    rs -> rs.getString("name")
);

Транзакции

try (Transaction tx = api.beginTransaction()) {
    tx.execute("UPDATE players SET level = level + 1 WHERE id = ?", java.util.Collections.singletonList(1));
    tx.commit();
} catch (Exception ex) {
    // rollback при ошибке
}