FROM SELECT - SELECT

FROM ... SELECT ...

An inverted format, first specifying the data source and then the operation.

FROM my_table SELECT key, value;

FROM a_table AS a
JOIN b_table AS b
USING (key)
SELECT *;