Skip to content

SQL language plugin

lang use sql rewrites sql { SELECT ... } blocks into sql_run("...") calls. With _sql.configure(url) (or COBRA4_SQL_URL) execution is real via SQLAlchemy.

Source: examples/07_sql_plugin.c4

# Demonstrates the M5 language-plugin system: `lang use sql` enables
# embedded SQL blocks. The plugin pre-processes `sql { ... }` into a
# call to the runtime helper `sql_run`, which in M5 just logs the query.

lang use sql

rows = sql {
    SELECT id, name, age FROM users WHERE age >= 18 ORDER BY name
}

log("rows fetched", count=len(rows))

Run it

c4 run examples/07_sql_plugin.c4