SQL and M4 = Composable SQL

• plpgsql

  2 0 10.0 PLpgSQL

  Misc SQL

I've found text manipulation of SQL can quickly degenerate into a nightmare of concatenation, nested quoting & escaping. I wrote up Using plain Jinja[1] or SQLAlchemy+Jinja[2] as an API as complementary techniques. The post is a bit dated but the principles should still work.

- [1](https://github.com/gregn610/plpgsql/wiki/meta-sql-with-pytho...)

- [2](https://github.com/gregn610/plpgsql/wiki/meta-sql-with-pytho...)

• dbt-core

  86 8,985 9.7 Python

  dbt enables data analysts and engineers to transform their data using the same practices that software engineers use to build applications.

  

• InfluxDB

  www.influxdata.com featured

  Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  

• jOOQ

  94 5,929 9.8 Java

  jOOQ is the best way to write SQL in Java

  

• RavenDB

  12 3,444 10.0 C#

  ACID Document Database

  

Suggest a related project