[jitl]

How do you know what the expression is though? Don’t you need to be parsing the SQL? If I have non standard SQL somewhere upstream in the text how does the parser cope?

[pgjones]

It does parse the SQL. At the moment an expression is defined as all the text between the appropriate separators given the clause.