Support for always true or false predicates in filters

[elonazoulay]

Feature request: Add support for always true or false in filters. This will facilitate autogenerated queries by other bi tools to work. Some examples: This may be the query generated (even though the TRUE can be elided, it may be autogenerated by a tool):

SELECT * FROM table WHERE (TRUE) AND (a = 3)

support for 1=0 or 1=1 (some bi tools use this form to generate predicates):

SELECT * FROM table WHERE (1 = 0)

[elonazoulay]

Related to #10600

[Jackie-Jiang]

This issue should be solved with #10444. Can you verify if it works?

[elonazoulay]

Awesome! Will do. For the trino connector we will have to wait until the next release though (for the maven artifacts). Thanks @Jackie-Jiang !