cgsql.dev

What It Is

CG/SQL is a code generation system for SQLite. It lets developers write stored procedures in a variant of Transact-SQL, then uses the CQL compiler to generate C code that calls the SQLite C API. It is not positioned as a general-purpose ORM; rather, it is designed to provide stronger type checking, code generation, schema management, and testing support for complex SQLite data access layers.

Core Capabilities

From a functionality perspective, CG/SQL’s main value is that it moves many runtime SQL/C API errors to compile time. The compiler tracks variable types and schema types, checks inconsistencies such as nullable values being assigned to non-nullable output variables, and ensures the generated code always checks SQLite return codes and uses the correct column ordinals and column types. This is especially valuable for teams that frequently add columns or modify tables and therefore need to maintain a large number of ordinals.

For schema management, CG/SQL can use annotations to automatically create stored procedures that upgrade older schema versions to the current version, with multiple checks included. Procedure annotations can also generate test code, schema fragments, and test data to support unit testing of stored procedures; they can also create schemas used for compile-time query plan checks. CG/SQL also supports JSON output, which can be used for further analysis or interface-code generation, and it mentions interoperability with languages such as Java and Objective-C.

Pricing and Documentation

The captured text does not show any paid plans, subscriptions, or enterprise edition information. The page provides links such as GitHub, Quick Start, Getting Started, CQL Guide, Internals, Railroad Diagram, Playground, and Blog, and claims to include extensive documentation. The open-source license and maintenance/support status are not clearly stated in the main text.

Pros, Cons, and Best Fit

Its strengths are strong typing, catching errors earlier, reducing repetitive and error-prone handwritten SQLite C API work, and providing schema upgrade and test-code generation. Its limitations are that its use case is relatively focused, mainly serving SQLite and C code generation; developers need to learn the CQL dialect and annotation system; and there is insufficient information about commercial support, licensing, and community activity. It is well suited to teams building complex local databases, mobile apps, or embedded data layers with SQLite, especially those that value maintainability and testing.

Access from China

The main text does not provide information about network accessibility, mirrors, payment, or China-specific support, so its access status is unknown. If access to GitHub or the documentation is unstable, alternatives or adjacent tools may be worth considering, such as SQLDelight, sqlc, Diesel, jOOQ, Prisma, and SQLite ORM, depending on the language stack and whether SQLite/C code generation is required.