I'm new to CI4 sql builder, I'm trying to query the postgresql json data type, for example:
$db->where("dataUser ->> 'level' ",'true');
or $db->query("select * from login ul where dataUser ->> 'level' = 'true'");
when i run getCompiledSelect,
SELECT * FROM "login" WHERE dataUser ->> 'level' > :dataUser -> > 'level':
and
SELECT * FROM "login"
what can i do?