SQL
Examples
Generate two rows and directly return them:  
```sql
VALUES ('Amsterdam', 1), ('London', 2);
```  
Generate two rows as part of a `FROM` clause, and rename the columns:  
```sql
SELECT *
FROM (VALUES ('Amsterdam', 1), ('London', 2)) cities(name, id);
```  
Generate two rows and insert them into a table:  
```sql
INSERT INTO cities
VALUES ('Amsterdam', 1), ('London', 2);
```  
Create a table directly from a `VALUES` clause:  
```sql
CREATE TABLE cities AS
SELECT *
FROM (VALUES ('Amsterdam', 1), ('London', 2)) cities(name, id);
```