Comment by peoplefromibiza

This is the kind of things that a well crafted DSL can solve, if the language you use supports macros.

PRQL looks very similar to Ecto, the Elixir Query DSL

https://hexdocs.pm/ecto/Ecto.Query.html