New feature: Add "IS [NOT] DISTINCT FROM" comparison operators to `Cond`
What's New
- Add "IS [NOT] DISTINCT FROM" comparison operators to
Cond
#169 - Automatically build compatible operators for a flavor.
- If a database system does not support an operator,
Cond
can automatically build compatible syntax as a substitute. - For example, calling
IsDistinctFrom("field", value)
automatically determines which expression to output based on the current database flavor. If the flavor isPostgreSQL
, it builds "field IS DISTINCT FROM $1". ForMySQL
, which does not support this operator, it builds the functionally equivalent expression "NOT field <=> ?".
- If a database system does not support an operator,
Full Changelog: v1.29.1...v1.30.0