jsonExists
open fun jsonExists(expression: Expression<*>, vararg path: String, optional: String?, jsonType: IColumnType<*>, queryBuilder: QueryBuilder)
SQL function that checks whether data exists within a JSON expression at the specified path.
Parameters
expression
JSON expression being checked.
path
String(s) representing JSON path/keys that match fields to check for existing data. Note: Multiple path arguments are not supported by all vendors; please check the documentation.
optional
String representing any optional vendor-specific clause or argument.
jsonType
Column type of expression to check, if casting to JSONB is required.
queryBuilder
Query builder to append the SQL function to.