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.