Comparison & Filter Operators

These operators cover numeric comparisons, logical combinators, bitwise operations, and special identifier access syntax. All four dialects support this category fully — there are no approximations or rewrites required.

Legend: ✅ Supported · ⚠️ Approximated · ❌ Not Supported · 🔄 Rewritten

Feature	SQLite	MySQL	ClickHouse	PostgreSQL	Notes
<, <=, >, >=	✅	✅	✅	✅
and / or / not	✅	✅	✅	✅
Bitwise &, |, ^, <<, >>	✅	✅	✅	✅
notin / notin~	✅	✅	✅	✅	Alias for !in / !in~
Bracketed identifiers ['col name']	✅	✅	✅	✅	Quoted identifiers per dialect
Dotted column access a.b	✅	✅	✅	✅	Mapped to JSONExtractString