Doesn’t change anything, you can still have the select at the end, and optional ...

thiht 64 days ago | parent | context | favorite | on: Pipe Syntax in SQL

Doesn’t change anything, you can still have the select at the end, and optional from and joins at the beginning. In your example, the select could be at the end, it’s just that there’s nothing before.