Module expr 

SQLite-specific SQL expressions and JSON helpers.

This module provides SQLite dialect functions and JSON expressions. For standard SQL expressions, use drizzle_core::expr.

Functions

json

Wraps a value with the SQLite json() function, validating and returning JSON text.

json_array_contains

Create a JSON array contains value condition

json_contains

Create a JSON field contains condition using json_extract

json_eq

Create a JSON field equality condition using SQLite ->> operator

json_exists

Create a JSON field exists condition using json_type

json_extract

Helper function for JSON extraction using ->> operator

json_extract_text

Helper function for JSON extraction as JSON text using -> operator

json_gt

Create a JSON numeric greater-than condition

json_ne

Create a JSON field inequality condition

json_not_exists

Create a JSON field does not exist condition

json_object_contains_key

Create a JSON object contains key condition

json_text_contains

Create a JSON text search condition using case-insensitive matching

jsonb

Wraps a value with the SQLite jsonb() function, validating and returning JSON in binary format.