If the goal is to get something written, of course. If the goal is to tinker with something that you enjoy, there’s no problem in endlessly redesigning your website with a single post on it.

score 1 · canonical

Although a pipeline can be a bit closer to how the database will do the work, and it’s easier to make explicit optimisations (moving filters up and selecting fewer fields early) compared to regular SQL. You’ve probably got to be ready to look at a query plan or profile at some point either way.

score 1 · canonical

I think that the DSLs that simply map to the existing SQL structure (like ActiveRecord) are less useful than ones that create a pipeline abstraction (like FunSQL). IMO the latter is much easier to compose programmatically or build extra helper functions, as each step is just a transform from one schema to another.

There are advantages of having your “main” or “real” language be aware of the queries so you can do cross-references, etc. Doing less string concatenation to build SQL also discourages people from accidentally/unknowningly creating an SQL injection vulnerability.

score 1 · canonical