0 | module Oracle.Internal.JSONQuery 1 | 2 | import Oracle.Types.JSONQuery 3 | 4 | ||| Construct the SQL used internally to retrieve a JSON value as a CLOB (String). 5 | ||| 6 | export 7 | buildJSONQuerySQL : JSONQuery -> String 8 | buildJSONQuerySQL query = 9 | "SELECT JSON_SERIALIZE(" ++ 10 | expression query ++ 11 | " RETURNING CLOB) FROM " ++ 12 | querybody query 13 |