22 Commits
Author SHA1 Message Date
Huan Du d882448972 fix #202: NotIn with empty values builds "0 = 0" 2025-06-13 00:58:47 +08:00
Huan Du 61ff9070f0 generate FALSE if values is empty in IN/ALL/SOME/ANY 2025-02-11 15:09:46 +08:00
Huan Du ee087fd12b ignore empty values and expressions to prevent syntax error 2025-01-26 15:35:02 +08:00
Huan Du d8cdbb7ceb fix #178: avoid stackoverflow when Cond is misused 2024-11-05 14:24:10 +08:00
Vasily Rodionov 9bf5964c7c fix #172: added checks for empty strings in conds. 2024-10-27 18:39:54 +05:00
Huan Du 4e13f47b93 fix #171: no need to escape field any more 2024-10-10 13:20:45 +08:00
Huan Du 619ac5820e reduce count of memory allocations in Cond.And/Or/Not 2024-09-24 14:40:15 +08:00
Huan Du 8329700531 fix #169: support IS [NOT] DISTINCT FROM operator 2024-09-23 22:03:08 +08:00
Valentin Lahaye 9d726b4cf4 feat(cond): add logical NOT and NOT ILIKE operators
Add Cond.Not and Cond.NotILike to build NOT and NOT ILIKE expressions.

Closes #167
2024-09-10 09:39:27 +02:00
Abanoub Fathy 4613287c0e add ILIKE method to Cond 2024-07-09 21:07:23 +03:00
Huan Du 96e64e9b7d feature: new builder WhereClause dedicated for WHERE 2024-04-13 23:32:24 +08:00
Huan Du 18543198f5 fix #125: add more alias funcs in Cond for readability 2023-11-04 14:42:56 +08:00
Huan Du 769091c858 refs #115: Generate SQL only when necessary values are set 2023-07-22 20:50:59 +08:00
Huan Du eb96df9e68 refs #100 add EXISTS/NOT EXISTS/ANY/SOME/ALL in Cond 2023-04-01 16:43:22 +08:00
Huan Du 477f4420d9 new feature: interpolate args in sql 2019-04-24 17:10:23 +08:00
Enzo Brands ea0dbdee39 Added Cond.And 2018-10-10 10:01:21 +02:00
Huan Du 724122b919 fix #11. change not equal operator from != to <>. 2018-06-27 19:02:58 +08:00
Huan Du 49ae34e062 fix typo in doc 2017-12-29 01:02:41 +08:00
Huan Du b475234df4 add doc and freestyle builder 2017-12-28 19:26:00 +08:00
Huan Du 8193c41814 add tests and doc 2017-12-28 01:33:30 +08:00
Huan Du 00e9158475 add E and NE alias 2017-12-28 00:44:59 +08:00
Huan Du 2f7b2c59bb init 2017-12-28 00:37:13 +08:00