CG/SQL

lastmod 2020-10-12created 2020-10-121 edits

A Stored Procedure code generator for SQLite.

CG/SQL is a compiler that converts a SQL Stored Procedure like language into C for SQLite. SQLite has no stored procedures of its own. CG/CQL can also generate other useful artifacts for testing and schema maintenance.

Features

• A compiler that converts stored procedures written in T-SQL into C code that uses the SQLite C API, for SQLite, which has no Stored Procedure
• Handles even very complex stored procedures made up of large queries well, and performs type and method checking
• Supports schema management/upgrades, writing test code, Java and Obj-C interop code, etc.
• Open source under the MIT license

See also

• SQLite

Favorite site

• Github - CG-SQL
• CG/SQL: Easy, accurate code generation for SQLite