JSONata for Postgres

I'm working on an application that relies heavily on heterogeneous JSON data. I use Supabase + TimescaleDB to take in telemetry payloads in a JSONB column. Then I use an edge function + the fabulous JSONata library parse transform & query those payloads. JSONata is kinda like Perl but for JSON data specifically. It's fast, lightweight, and extremely powerful. While this is awesome and works wonderfully, I can't help but wonder if it could be _better_. Just like pg_jsonschema, I would love to see a pg_jsonata (perhaps as a pglet on database.dev?) that would allow evaluation of jsonata expressions against json & jsonb columns as a set of functions. It would allow me to have users define queries and transformation rules as JSONata expressions in my app and store them, then allow postgres to directly parse that data as needed without needing to call an edge function. Again, nothing wrong with the edge function! But would be more convenient and far less maint…