doubleg

From their About: “Work on Climate quickly built the world’s largest and most successful community of its sort – with tens of thousands of members around the globe, thousands of whom have found climate jobs and started companies”.

Not affiliated but I ran into this initiative recently.

I was reminded of this gist when reading the discussion about MinIO (https://news.ycombinator.com/item?id=47000041).

You put queries in a file `app/queries/foo.sql.erb`. Casting works and can be customised. There's ERB-support for parameterisation, with helpers like order_by and paginate.

The gem can parse and rewrite CTEs which allows for 1) rewriting the query such that basic queries (first, take, count etc.) are performant (Rails does `resultset.count`). And 2) given your query contains CTEs, it allows to write tests per CTE.

[1]: https://building.nubank.com/clojure-developer-advocate-nuban...

EDIT: wording.

[^1]: https://polar.sh/