Better support for JSONB
Open
types
- Dominant language
- C++
- Stars
- 3.2k
- Forks
- 204
- PR merge metrics
- No merged PRs in 30d
Description
### Description
We currently only support the Postgres `json` type, not the `jsonb` type. The `jsonb` type is much more common in practice in Postgres though, so we should support it. Related to #513.
- [x] 0. Conversion between JSONB type and DuckDB (#513)
- [x] 1. Start supporting some of duckdb its [JSON functions](https://duckdb.org/docs/data/json/json_functions) (#546)
- [ ] 2. Introduce some of the JSONB operators that postgres supports to DuckDB.
- [ ] 3. Introduce a PG compatibility mode in duckdb to make existing operators behave exactly the same.
Contributor guide
Assessment
This issue has not been assessed yet.