3 ms·
What's the intended syntax for a WHERE clause connecting two columns with an operator? There are three different shapes in the examples: * in "predicate1" arou
by al2o3cr 4y ago
What's the intended syntax for a WHERE clause connecting two columns with an operator? There are three different shapes in the examples:
* in "predicate1" around "groupedField4", a special "valueSource" key alongside "field" and "operator"
* in "get_active_users" around "tier_id", a "::field" suffix
* in "simple" around "client_id", a bare column name in "value"
- revskill 4y agoThanks. Good feedback. That's first confusion point (for myself included). My improvement plan is: - Remove that valueSource - Allow raw sql string for field and value for operator. Actually field and value in this case is left and right operand.