opteryx
opteryx copied to clipboard
✨ Introduce BSON field type
trafficstars
record in Parquet, etc, as BLOB, but parse to dictionary-like field field
implement optimizations for the existing ->, ->> and @? operators
implement functions:
- [ ] SELECT EXTRACT_PATH(bson_field, 'address.city') FROM my_table;
- [ ] SELECT CAST(bson_field->'age' AS INTEGER) FROM my_table;
- [ ] SELECT FILTER(bson_field->'orders', 'order.amount > 100') FROM my_table;
This is a virtual type only, it's binary blob on storage.
This would be tarchia defined tables only.