[jcheng]

Or better yet, use CTEs: https://duckdb.org/docs/stable/sql/query_syntax/with.html

[cess11]

Absolutely, if the engine has them and they're not wonky somehow.