Selecto.Builder.JsonOperations (Selecto v0.3.14)
SQL generation for PostgreSQL JSON operations.
Generates SQL for JSON path queries, aggregation, manipulation, and testing functions. Supports both JSON and JSONB column types with proper parameter binding and PostgreSQL-specific syntax.
Link to this section Summary
Functions
Generate SQL for a JSON operation in WHERE clauses.
Generate SQL for multiple JSON operations.
Generate SQL for a JSON operation in SELECT clauses.
Link to this section Functions
Link to this function
build_json_filter(spec)
Generate SQL for a JSON operation in WHERE clauses.
Returns SQL iodata suitable for filtering conditions.
Link to this function
build_json_operations(specs)
Generate SQL for multiple JSON operations.
Returns {sql_iodata, parameters} tuple for batch operations.
Link to this function
build_json_select(spec)
Generate SQL for a JSON operation in SELECT clauses.
Returns SQL iodata with proper function calls and parameter binding.