sql-metadata does not understand VALUES Lists constructs

[YoannQDQ]

Example (Postgresql) : https://www.postgresql.org/docs/9.4/queries-values.html

>>> from sql_metadata import Parser
>>> SQL = "SELECT * FROM (VALUES (1), (2), (3)) AS X(a);"
>>> Parser(SQL).tables
["VALUES"]

[collerek]

@macbre how do you see this?

For me it's more an enhancement than a bug as this use of values is a generative function like the ones described in #166 . In sample provided there is no real table or column. a is a column alias but refer to manually typed values and not real db column/data.

[macbre]

@collerek - you're right, this does look more like an enhancement then a bug.