Inline Table

    • expression

    • table_alias

      Syntax: 

    1. -- single row, without a table alias
    2. SELECT * FROM VALUES ("one", 1);
    3. +----+----+
    4. +----+----+
    5. | one|   1|
    6. +----+----+
    9. SELECT * FROM VALUES ("one", 1), ("two", 2), ("three", null) AS data(a, b);
    10. +-----+----+
    11. |    a|   b|
    12. +-----+----+
    13. |  one|   1|
    14. |three|null|
    15. +-----+----+
    17. -- complex types with a table alias
    18. SELECT * FROM VALUES ("one", array(0, 1)), ("two", array(2, 3)) AS data(a, b);
    19. +---+------+
    20. |  a|     b|
    21. +---+------+
    22. |one|[0, 1]|
    23. |two|[2, 3]|