brikk-sql

SQL parsing, transpilation, optimization, metadata, and verification for Kotlin. The generic SQL implementation is a multiplatform port of sqlglot, with first-class pipe syntax and documented Brikk extensions.

Extracted from brikk-house, preserving relevant Git history and existing Maven coordinates. Kotlin Engine integration remains in brikk-house; embedded chDB is maintained in brikk-chdb.

All artifacts use the dev.brikk.house group:

Core and metadata target JVM for current publications and retain the -jvm coordinates. They emit Java 21-compatible bytecode. Verification modules require JDK 25. The heavyweight oracle consumes dev.brikk.house:brikk-chdb:0.16.0 from Maven Central, without a sibling source checkout or bundled native engine.

Latest release: 0.18.0. Current development snapshot: 0.19.0-SNAPSHOT.

repositories { mavenCentral() }
dependencies {
    implementation("dev.brikk.house:brikk-sql-jvm:0.18.0")
    // Optional: implementation("dev.brikk.house:brikk-sql-verify:0.18.0")
}

Supported names: sqlglot (also ""), mysql, doris, starrocks, postgres (postgresql), duckdb, presto, trino, clickhouse, hive, spark2, spark (sparksql), bigquery, and datafusion (arrow-datafusion). Names are case-insensitive. Use read=<dialect> when parsing and write=<dialect> when transpiling.

SQLGlot-backed dialects are checked differentially against the pinned Python oracle. DataFusion is Brikk-native: its gates use polyglot fixtures, DataFusion sqllogictest parse acceptance, and hand assertions instead. StarRocks is pinned to 4.1.4 with a versioned catalog and a deliberately partial evidence-backed semantic matrix; unprobed functions do not receive inferred certification.

See the core API guide, corpus coverage policy, and vendor provenance. Current priorities and ownership: work list (SQL-*).

New in 0.17.0: source-preserving executable lowering retains proved native text while lowering pipes and reports regenerated intervals. The opt-in API leaves the existing rendering paths unchanged.

0.18.0 adds the DDB-001 DuckDB template-projection fix and updates the DuckDB reference engine/catalogs to 1.5.6 (JDBC 1.5.6.0).

Use the pinned Kotlin Toolchain 0.13.0 wrapper. Kotlin remains pinned to 2.4.10. On a fresh checkout, create a placeholder credentials file for the publish-only repository configuration; real credentials are needed only to publish:

printf 'brikk.mavencentral.user=x\nbrikk.mavencentral.pass=x\n' > .env
./kotlin build
./kotlin test
./kotlin publish mavenLocal

No Engine plugin assembly, sibling repository, Python oracle checkout, or native chDB installation is needed for the normal build/test suite. Committed fixtures and the vendored Doris parser are sufficient. The optional explicit-library ClickHouse integration test skips when its library property is not configured. Corpus failures write review artifacts under build/ledger-actual/.

Generators live in tools/. Some require pinned, gitignored upstream checkouts under reference/; see the research and vendor documentation before refreshing them. The consumer verification harness validates candidate SQL JARs against a separate Doris IDE consumer.

This repository publishes only the four SQL artifacts above. The module template owns the version, sources, POM metadata, and repository URLs.

• Push to main: build, full tests, and Maven Local publication gate, then publish 0.19.0-SNAPSHOT to https://central.sonatype.com/repository/maven-snapshots/.
• Push release/<version> or manually dispatch the release workflow: the same gate, then signed Maven Central release bundles.
• Local snapshot: ./kotlin publish centralSnapshots.
• Local release: ./publish-release.sh <version>.

Required GitHub organization/repository secrets: KOTLIN_TOOLCHAIN_MAVENCENTRAL_USERNAME, KOTLIN_TOOLCHAIN_MAVENCENTRAL_PASSWORD, KOTLIN_TOOLCHAIN_SIGNING_KEY, and KOTLIN_TOOLCHAIN_SIGNING_PASSPHRASE. The workflows also accept KOTLIN_TOOLCHAIN_MAVEN_CENTRAL_USERNAME/PASSWORD. For local snapshots, .env uses brikk.mavencentral.user/pass; local releases use Python 3 (standard library only) and the corresponding KOTLIN_TOOLCHAIN_* environment variables. The release launcher validates SemVer 2.0.0, composes a temporary Toolchain template override for the version/Portal/signing settings, and restores the original even on failure or termination. It invokes the explicit Portal tasks rather than the repository-validation-sensitive publish mavenCentral command. Do not reuse an already published version. SQL and chDB release versions can now advance independently.

Snapshots resolve by adding the snapshots repository explicitly. Releases resolve from Maven Central with no extra repository.

Apache-2.0; see LICENSE and ATTRIBUTIONS.md, including the retained MIT notices for SQLGlot-derived code and fixtures.