Due to this one should not manually order the output if you are expecting to be able to replay the SQL directly from the VIEW query result. It is still possible to order if you filter out the FOREIGN ...

For a video introduction on Squirrel's philosophy and general developer experience you can check out my talk from FOSDEM 2026: You Don't Need an ORM. If you need to talk with a database in Gleam ...