@b0rk_reruns This is basically how LINQ does it in C#

@b0rk_reruns this isn't even the biggest problem with select. It's not selecting rows. Many DB people call it "project".

@b0rk_reruns having an explainer that shows "explain plan" for a sample query could be a logical follow up. One could argue that it's too complex for your audience. But you have the skill to present complex things in a way people can actually understand.

@b0rk_reruns the ORM I use allows composing query concepts in any order technically, but in practice it almost always starts from a "from" base concept (like, DV[:some_table] is "SELECT * FROM some_table", but filtering with WHERE and only some cols could be DB[:some_table].filter(some_col: 'value').select(:col1, :col2)). Might be one of the unconscious reasons I like it, since it maps to this better mental model of building SQL statements

This is syntax that rdbms clients could support. It’d also help with column name completion if you start with FROM.