[SQLime] test relation query result

query.sql

SELECT users.*, posts.*
FROM users
INNER JOIN posts ON posts.user_id = users.id;

schema.sql

BEGIN TRANSACTION;
PRAGMA writable_schema=ON;

CREATE TABLE IF NOT EXISTS users (
  id    integer primary key,
  name  varchar(255) NOT NULL
);

CREATE TABLE IF NOT EXISTS posts (
  id       integer primary key,
  user_id  integer NOT NULL,
  title    varchar(255) NOT NULL
);

INSERT INTO "users" VALUES(1, "user-1");
INSERT INTO "users" VALUES(2, "user-2");
INSERT INTO "users" VALUES(3, "user-3");

INSERT INTO "posts" VALUES(1, 1, "user-1-A");
INSERT INTO "posts" VALUES(2, 2, "user-2-A");
INSERT INTO "posts" VALUES(3, 3, "user-3-A");
INSERT INTO "posts" VALUES(4, 1, "user-1-B");
INSERT INTO "posts" VALUES(5, 2, "user-2-B");
INSERT INTO "posts" VALUES(6, 2, "user-2-C");
INSERT INTO "posts" VALUES(7, 3, "user-3-B");

PRAGMA writable_schema=OFF;
COMMIT;