mirror of
https://github.com/russ-p/sqlbuilder.git
synced 2025-12-14 01:04:25 +00:00
1c86d3fafa
Bumps [h2](https://github.com/h2database/h2database) from 1.4.194 to 2.1.210. - [Release notes](https://github.com/h2database/h2database/releases) - [Commits](https://github.com/h2database/h2database/compare/version-1.4.194...version-2.1.210) --- updated-dependencies: - dependency-name: com.h2database:h2 dependency-type: direct:development ... Signed-off-by: dependabot[bot] <support@github.com>
sqlbuilder
simple sql builder
From
String sql = Sql.select()
.column("id").as("col_id")
.column("code").as("col_code")
.from("test_table")
.where("id = 1")
.groupBy("id")
.orderBy("id").by("code").desc()
.toString();
to
SELECT
id AS col_id,
code AS col_code
FROM
test_table
WHERE
id = 1
GROUP BY
id
ORDER BY id, code DESC