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.

Parse SQL into an editable AST, render it for another dialect, resolve columns and output types, or lower pipe queries while preserving the surrounding SQL text.

All artifacts use the dev.brikk.house group:

Core, metadata, the verification API and the Doris verifier require Java 17. Other verifiers and IntelliJ support require Java 21; Trino, the aggregate verifier and the oracle require Java 25. See Java 17 embedding for dependency guidance.

Latest core, metadata, verify and oracle release: 1.0.1. SQL IntelliJ support is independently versioned at 1.0.1.

All SQL and IntelliJ support artifacts are published on Maven Central at 1.0.1. Development versions are aligned at 1.0.2-SNAPSHOT.

In development, SqlVerifier now extends AutoCloseable with a JVM-default no-op close(). Kotlin implementers with their own close() must mark it override; Java implementers' close() cannot declare checked exceptions. Callers own registry results: reuse them, then close them (or use use {}); closed resource-holding verifiers return VerifyResult.Unavailable, while stateless verifiers inherit the no-op.

repositories { mavenCentral() }
dependencies {
    implementation("dev.brikk.house:brikk-sql-jvm:1.0.1")
    // Optional, Java 25 runtime: implementation("dev.brikk.house:brikk-sql-verify:1.0.1")
}

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

Function catalogs provide engine-specific names, overloads, keywords and types. Semantic diagnostics flag translations whose behavior differs between engines.

DuckDB support targets 2.0.0 LTS, with JDBC 2.0.0.0. It covers UPDATE/MERGE, DML CTEs, keyed recursion, nested SQL names, NEAREST joins, VARIANT, COPY options, and session/resource statements, with scope resolution and type inference for supported forms.

Editor verification parses SQL without running it. Cross-dialect executable generation rejects unsupported translations. See the DuckDB API guide for feature-specific behavior and limits.

The Trino target is 484, including its SQL/JSON constructor and serialization forms, interval precision, window-frame exclusion and NEAREST relations. The native parser and captured metadata use the same version. See the compatibility notes.

ClickHouse support includes STREAM reads, Tuple aggregate combinators, structured DDL, name-filtered stars, higher-order functions and versioned metadata for 26.5, 26.8 LTS and 26.10. Streaming and experimental LATERAL depend on server settings.

DataFusion 55.2.0 and Spice 2.4.0 have separate dialects, function catalogs and IntelliJ integrations. See the support guide and consumer wiring guide. StarRocks metadata targets 4.1.4.

• Core API and examples
• Source-preserving SQL lowering
• IntelliJ integration
• SQL and IntelliJ support 1.0.1 release record
• SQL and IntelliJ support 1.0.0 release record
• SQL 0.23.0 and IntelliJ 0.4.0 release record
• IntelliJ 0.4.1 catalog-race fix
• Dialect differences and extensions
• Building, testing and publishing
• Developer work list

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