I am trying to find the right description for the parts of a query:
- What is the name of the part between
FROM? If I only had some columns then I would call it "column identifiers". But if there are any function or subqueries this would be quite a bit more. Is "SELECT clause" a valid description?
- Same thing for the
FROMpart. If I have only one table I would simply call it "table". But if there is a more complicated structure maybe using joins, etc. what would be the correct naming?
To make my questions more clear:
In Postgres I could use a JSON function, e.g.
json_array_elements in both parts:
SELECT json_array_elements(my_json_column) FROM my_table
or doing this
SELECT elem.* FROM my_table, json_array_elements(my_json_column) AS elem
If I have to tell somebody that this function can be used within the
SELECT clause or as part of the
FROM clause which terms are more conventional?