* fix(preflight): sorts by output columns and generate_series aliases are not whole rows (#374)
With a column policy on a table, the column check refused two shapes of
SQL that read no row:
- ORDER BY a name that is an output column named like a table
(count(*) AS users ... ORDER BY users). PostgreSQL, MySQL and SQLite
sort by the output column there. Only a whole ORDER BY item that names
an output alias of its own query passes; in an expression, GROUP BY or
a window the name is still taken for the row.
- The alias of generate_series or generate_subscripts in FROM, and its
column alias list, which name a number or a time. Their arguments are
still checked. Other functions' aliases stay refused, as the check
can't know what a function returns.
Co-authored-by: Claude <noreply@anthropic.com>
(cherry picked from commit 3222b5474924fc7878c6df73c6b4b80207095f1b)
* chore(release): 1.3.2
---------
Co-authored-by: Claude <noreply@anthropic.com>