VALUES lets you create an ad-hoc list.
SELECT * FROM (VALUES (1, 'A'), (2, 'b'), (3, 'C')) AS foo (num, title)Code language: SQL (Structured Query Language) (sql)returns:
| num | title |
|---|---|
| 1 | A |
| 2 | b |
| 3 | C |
It is nice to be able to make a VALUES list to pass in a list you want to filter by with a readable value and an ID for joining, then LEFT JOIN with the other tables to pull in the data you are interested in.
Docs for VALUES:
- From the Trino engine, which is one of the two being used in Hue.
- MySQL
- SQL Server
- PostgreSQL