CG/SQL – SQL dialect compiler to C for sqlite3 mimicking stored procedures (ricomariani.github.io)

CG-SQL = an attempt to give C what Python has had for a long timeconvenient “scripted” work with the database, but without losing speed.This is cool.

I'm guessing this is a fork of Facebook's abandoned library? https://github.com/facebookincubator/CG-SQL

Is it safe?

I always wonder why SQLite didn't expose a programmatic way for creating a query (as opposed to parsing SQL statements). Given that it was designed to be embedded, it seems to me that it would have made far more sense to provide an API based interface. Then, for example, stored procedures would just be function pointers passed as callbacks.