TODO

Random notes for later. No particular order!

• MySQL backend
• Custom backend-specific types
• Better way to define functions with tricky translations (functions that translate to operators or have weird clauses)
• Order-by at runtime
• Inline functions
• Inline CTEs
• Inline views
• Table-valued functions (builtin and inline)
• Way to indicate "cascade" effects for insert/updates (to be used in IMAGINE clause of CREATE TRIGGER vendor stmts)
• Plugins
• Linters (= NULL is always false, DELETE w/o WHERE clause, etc.), ideally via plugins
• Allow dynamic SQL to be added at runtime (e.g. select ... where unsafe_inject(@whereClause))
• Make sure ORDER BY 1 doesn't ever mean order by 1st col on backend
• Make sure we can ORDER BY result column aliases(?)
• Interpreted in-memory execution (including replicas of of backend functions) for use in testing