feat(electric-db-collection): support nested property references in SQL queries #1514
Closedmiguelrk(GitHub profile, opens in a new tab)wants to merge 1 commit into
main fromrefs/pull/1514/headopened KyleAMathews(GitHub profile, opens in a new tab) closed this
Sign in to join this conversation.
Closing because this capability cannot be implemented solely in the TanStack Electric collection compiler. The generated nested-path filter uses PostgreSQL JSON operators (
->/->>), but Electric's Shape server validates and evaluates WHERE expressions with its own expression engine, which does not support those JSON extraction operators. We are not planning the required Electric server work.\n\nThe current candidate also cannot safely land independently: final->>extraction coerces JSON numbers to text, changing numeric filtering and ordering semantics. Thanks @miguelrk for exploring the compiler side and documenting the intended behavior.