[bafe]

Thanks for the clarification! I'll read more about it, I'm quite curious to see how these clauses are implemented in Trino

[hashhar]

This is the initial PR which implemented support for this - https://github.com/trinodb/trino/pull/6550