Hello ! And here is the database dump for the example:
___________
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE users(id INTEGER PRIMARY KEY, name TEXT, json_misc TEXT);
INSERT INTO "users" VALUES(1,'Domingo','{"color":"cyan", "has_eyes": true}');
CREATE TABLE "unql_users"(x);
INSERT INTO "unql_users"
VALUES('{"id":1,"name":"Domingo","color":"cyan","has_eyes":true}');
CREATE VIEW users_unql AS SELECT json_misc AS x FROM users;
COMMIT;
___________
?
