Support SQLite jsonb
- Dominant language
- C#
- Stars
- 14.8k
- Forks
- 3.4k
- PR merge metrics
- PR metrics pending
Description
SQLite version 3.45.0 (2024-01-15) introduced support for stored JSON data in its internal representation format, as a BLOB ([docs](https://www.sqlite.org/json1.html#jsonb)), similar to PG jsonb or the new SQL Azure JSON type. We should make sure to support this:
* Understand how a client encodes JSON (string) data to write it into a SQLite JSON BLOB column. Since there's no column type (like in PG, SQL Server), I'm assuming some function call converts the string data into the internal binary format. This function call would need to be integrated into our update pipeline, etc.
* Make sure we allow users to map primitive collections and JSON-mapped complex/owned entity types to BLOB.
* Include partial update support in the update pipeline
* Include partial update support in ExecuteUpdate
Contributor guide
Assessment
This issue has not been assessed yet.