sql¶
Run SQL against the active dataset exposed as active.
When to use
How do I express a query that is easier in SQL than in command syntax?
An explicit order by controls the listed-key sequence. Include tie-breaker keys for a reproducible
total order. sql ... into name preserves that sequence in the active named table; SQL without
order by has no row-order guarantee.