opteryx icon indicating copy to clipboard operation
opteryx copied to clipboard

✨ Introduce BSON field type

Open joocer opened this issue 1 year ago • 0 comments
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.

joocer avatar Jun 29 '24 16:06 joocer