SELECT * FROM "images" WHERE "imageable_id" = \'3\' AND "imageable_type" = \'\mako\tests\integration\database\midgard\relations\HasOnePolymorphicProfile\' LIMIT 1', $this->connectionManager->connection('sqlite')->getLog()[3]['query']);
SELECT * FROM "articles" WHERE "autoeagerloadinguser_id" = \'1\'', $this->connectionManager->connection('sqlite')->getLog()[1]['query']);
SELECT * FROM "foobar" WHERE EXISTS (SELECT * FROM "barfoo" WHERE "barfoo"."foobar_id" = foobar.id) OR EXISTS (SELECT * FROM "barfoo" WHERE "barfoo"."foobar_id" = barbaz.id)', $query['sql']);
SELECT * FROM "foo"';
SELECT * FROM (' . $sql . ') AS mako1 WHERE mako_rownum BETWEEN ' . $offset . ' AND ' . $limit;
SELECT * FROM [foobar] WITH (HOLDLOCK, ROWLOCK)', $query['sql']);
SELECT * FROM "profiles" ORDER BY "id" ASC', $this->connectionManager->connection('sqlite')->getLog()[0]['query']);
SELECT * FROM `foobar` LOCK IN SHARE MODE', $query['sql']);
SELECT * FROM "foobar" ORDER BY "foo" ASC, "bar" DESC', $query['sql']);
SELECT * FROM "foobar" LEFT OUTER JOIN "barfoo" ON "barfoo"."foobar_id" = SUBSTRING("foo", 1, 2)', $query['sql']);
SELECT * FROM "articles" WHERE "user_id" IN (\'1\', \'2\', \'3\')', $this->connectionManager->connection('sqlite')->getLog()[1]['query']);
SELECT * FROM "images" WHERE "imageable_type" = \'\mako\tests\integration\database\midgard\relations\HasOnePolymorphicProfile\' AND "imageable_id" IN (\'1\', \'2\', \'3\')', $this->connectionManager->connection('sqlite')->getLog()[1]['query']);
SELECT * FROM "foobar" WHERE "foo" IN (SELECT id FROM barfoo)', $query['sql']);
SELECT * FROM "foobar" WHERE "foo" NOT BETWEEN ? AND ?', $query['sql']);
SELECT * FROM "foobar" WHERE "foo" IN (?, ?, ?) OR "foo" IN (?, ?, ?)', $query['sql']);
SELECT * FROM [foobar] ORDER BY (SELECT 0) OFFSET 0 ROWS FETCH NEXT 10 ROWS ONLY', $query['sql']);
SELECT * FROM "foobar" ORDER BY "foo" DESC', $query['sql']);
SELECT COUNT(*) FROM "foobar"', $query['sql']);
SELECT * FROM "articles" WHERE "id" = 1 LIMIT 1', $this->connectionManager->connection('sqlite')->getLog()[0]['query']);
SELECT * FROM "polymorphic_comments" WHERE "commentable_type" = \'\mako\tests\integration\database\midgard\relations\HasManyPolymorphicArticle\' AND "commentable_id" IN (\'1\', \'2\', \'3\')', $this->connectionManager->connection('sqlite')->getLog()[1]['query']);
SELECT * FROM (SELECT *, ROW_NUMBER() OVER (ORDER BY (SELECT 0)) AS mako_rownum FROM "foobar") AS mako1 WHERE mako_rownum BETWEEN 1 AND 10', $query['sql']);
SELECT * FROM "profiles" WHERE "user_id" = \'2\' LIMIT 1', $this->connectionManager->connection('sqlite')->getLog()[2]['query']);
SELECT * FROM "foobar" ORDER BY (SELECT 0) OFFSET 10 ROWS FETCH NEXT 10 ROWS ONLY', $query['sql']);
SELECT * FROM "foobar" ORDER BY FIELD(id, 1, 2, 3) DESC', $query['sql']);
SELECT * FROM "foobar" WHERE "foo" = ?', $query['sql']);
SELECT * FROM "polymorphic_comments" WHERE "commentable_type" = \'\mako\tests\integration\database\midgard\relations\HasManyPolymorphicArticle\' AND "comment" = \'does not exist\' AND "commentable_id" IN (\'1\', \'2\', \'3\')', $this->connectionManager->connection('sqlite')->getLog()[1]['query']);
SELECT * FROM "articles" WHERE "autoeagerloadinguser_id" IN (\'1\', \'2\', \'3\')', $this->connectionManager->connection('sqlite')->getLog()[1]['query']);
SELECT * FROM "foobar" WHERE "foo" = ? OR "foo" = ?', $query['sql']);
SELECT * FROM "foobar" WHERE NOT EXISTS (SELECT * FROM "barfoo" WHERE "barfoo"."foobar_id" = foobar.id) OR NOT EXISTS (SELECT * FROM "barfoo" WHERE "barfoo"."foobar_id" = barbaz.id)', $query['sql']);
SELECT * FROM "foobar" LEFT OUTER JOIN "barfoo" ON "barfoo"."foobar_id" = "foobar"."id"', $query['sql']);
SELECT * FROM [foobar] ORDER BY [foo] DESC OFFSET 10 ROWS FETCH NEXT 10 ROWS ONLY', $query['sql']);
SELECT * FROM "foobar" LIMIT 10', $query['sql']);
SELECT * FROM [foobar] CUSTOM LOCK', $query['sql']);
SELECT * FROM "foobar" ORDER BY FIELD(id, 1, 2, 3) ASC', $query['sql']);
SELECT * FROM (SELECT * FROM "foobar")', $query['sql']);
SELECT * FROM "users" LIMIT 10 OFFSET 0', $this->connectionManager->connection()->getLog()[1]['query']);
SELECT * FROM "users" WHERE "id" = \'2\' LIMIT 1', $this->connectionManager->connection('sqlite')->getLog()[2]['query']);
SELECT * FROM "foobar" CUSTOM LOCK', $query['sql']);
SELECT * FROM "foobar" ORDER BY (SELECT 0) FETCH FIRST 10 ROWS ONLY', $query['sql']);
SELECT * FROM "foobar" ORDER BY (SELECT 0) OFFSET 10 ROWS', $query['sql']);
SELECT * FROM "foobar"', $query['sql']);
SELECT * FROM "foobar" INNER JOIN "barfoo" ON "barfoo"."foobar_id" = SUBSTRING("foo", 1, 2) OR "barfoo"."foobar_id" != SUBSTRING("foo", 1, 2)', $query['sql']);
SELECT * FROM "foobar" WHERE "foo" IS NULL OR "bar" IS NULL', $query['sql']);
SELECT * FROM "users" WHERE "id" = \'1\' LIMIT 1', $this->connectionManager->connection('sqlite')->getLog()[1]['query']);
SELECT * FROM "users" WHERE "id" IN (\'1\', \'2\', \'3\')', $this->connectionManager->connection('sqlite')->getLog()[1]['query']);
SELECT * FROM "foobar" WHERE "foo" NOT IN (?, ?, ?)', $query['sql']);
SELECT * FROM [foobar] WITH (UPDLOCK, ROWLOCK)', $query['sql']);
SELECT * FROM "foobar" ORDER BY "foo" DESC OFFSET 10 ROWS FETCH NEXT 10 ROWS ONLY', $query['sql']);
SELECT * FROM [foobar] ORDER BY (SELECT 0) OFFSET 10 ROWS FETCH NEXT 10 ROWS ONLY', $query['sql']);
SELECT * FROM "foobar" INNER JOIN "barfoo" ON "barfoo"."foobar_id" = "foobar"."id"', $query['sql']);
SELECT * FROM "foobar" INNER JOIN "barfoo" ON "barfoo"."foobar_id" = "foobar"."id" OR "barfoo"."foobar_id" != "foobar"."id"', $query['sql']);
SELECT * FROM "profiles" WHERE "user_id" = \'3\' LIMIT 1', $this->connectionManager->connection('sqlite')->getLog()[3]['query']);
SELECT * FROM "profiles" WHERE "user_id" IN (\'1\', \'2\', \'3\')', $this->connectionManager->connection('sqlite')->getLog()[1]['query']);
SELECT * FROM (SELECT * FROM "foobar") AS "table_alias"', $query['sql']);
SELECT * FROM "users" WHERE "id" = 1 LIMIT 1', $this->connectionManager->connection('sqlite')->getLog()[0]['query']);
SELECT * FROM `foobar` FOR UPDATE', $query['sql']);
SELECT * FROM "foobar" WHERE "foo" IS NOT NULL', $query['sql']);
SELECT * FROM "foobar" ORDER BY "foo" DESC FETCH FIRST 10 ROWS ONLY', $query['sql']);
SELECT * FROM "users" ORDER BY "id" ASC LIMIT 10 OFFSET 0', $this->connectionManager->connection()->getLog()[1]['query']);
SELECT * FROM "foobar" ROWS 11 TO 20', $query['sql']);
SELECT * FROM "images" WHERE "imageable_id" = \'1\' AND "imageable_type" = \'\mako\tests\integration\database\midgard\relations\HasOnePolymorphicProfile\'', $this->connectionManager->connection('sqlite')->getLog()[1]['query']);
SELECT * FROM `foobar` LIMIT 10', $query['sql']);
SELECT * FROM "articles" WHERE "user_id" = \'2\'', $this->connectionManager->connection('sqlite')->getLog()[2]['query']);
SELECT * FROM "foobar" WHERE "foo" IN (SELECT "id" FROM "barfoo")', $query['sql']);
SELECT * FROM "groups" WHERE "id" = 1 LIMIT 1', $this->connectionManager->connection('sqlite')->getLog()[0]['query']);
SELECT * FROM "profiles" WHERE "user_id" = \'1\' LIMIT 1', $this->connectionManager->connection('sqlite')->getLog()[1]['query']);
SELECT * FROM "foobar" LIMIT 10 OFFSET 10', $query['sql']);
SELECT COUNT(*) FROM "users"', $this->connectionManager->connection()->getLog()[0]['query']);
SELECT * FROM [foobar] ORDER BY [foo] DESC OFFSET 0 ROWS FETCH NEXT 10 ROWS ONLY', $query['sql']);
SELECT * FROM "foobar" WHERE "foo" NOT IN (?, ?, ?) OR "foo" NOT IN (?, ?, ?)', $query['sql']);
SELECT * FROM "foobar" WHERE "foo" IS NULL', $query['sql']);
SELECT * FROM "images" WHERE "imageable_id" = \'1\' AND "imageable_type" = \'\mako\tests\integration\database\midgard\relations\HasOnePolymorphicProfile\' LIMIT 1', $this->connectionManager->connection('sqlite')->getLog()[1]['query']);
SELECT * FROM "foobar" WHERE LOWER("foo") = ?', $query['sql']);
SELECT * FROM "foobar" ORDER BY "foo", "bar" DESC', $query['sql']);
SELECT * FROM "foobar" WHERE ("foo" = ? AND "bar" = ?)', $query['sql']);
SELECT * FROM "foobar" FOR UPDATE', $query['sql']);
SELECT * FROM "users" WHERE "username" = \'does not exist\' AND "id" IN (\'1\', \'2\', \'3\')', $this->connectionManager->connection('sqlite')->getLog()[1]['query']);
SELECT * FROM [foobar] ORDER BY [foo] DESC OFFSET 10 ROWS', $query['sql']);
SELECT * FROM "polymorphic_comments" WHERE "commentable_id" = \'1\' AND "commentable_type" = \'\mako\tests\integration\database\midgard\relations\HasManyPolymorphicArticle\'', $this->connectionManager->connection('sqlite')->getLog()[1]['query']);
SELECT * FROM "foobar" WHERE "foo" = ? AND "bar" = ?', $query['sql']);
SELECT * FROM "articles" WHERE "user_id" = \'1\'', $this->connectionManager->connection('sqlite')->getLog()[1]['query']);
SELECT * FROM "foobar" WHERE "foo" BETWEEN ? AND ?', $query['sql']);
SELECT * FROM "foobar" INNER JOIN (SELECT * FROM "barfoo" WHERE "id" > ?) AS "barfoo" ON "barfoo"."foobar_id" = "foobar"."id"', $query['sql']);
SELECT * FROM `foobar`', $query['sql']);
SELECT * FROM "foobar" ORDER BY "foo" ASC', $query['sql']);
SELECT * FROM "users"', $this->connectionManager->connection()->getLog()[0]['query']);
SELECT * FROM "profiles" WHERE "user_id" = \'1\'', $this->connectionManager->connection('sqlite')->getLog()[1]['query']);
SELECT 1 FROM DUAL');
SELECT * FROM "foobar" WHERE "foo" NOT BETWEEN ? AND ? OR "foo" NOT BETWEEN ? AND ?', $query['sql']);
SELECT 1 FROM SYSIBM.SYSDUMMY1');
SELECT * FROM "profiles" WHERE "interests" = \'does not exist\' AND "user_id" IN (\'1\', \'2\', \'3\')', $this->connectionManager->connection('sqlite')->getLog()[1]['query']);
SELECT * FROM "users" LIMIT 1', $this->connectionManager->connection()->getLog()[0]['query']);
SELECT * FROM "articles" WHERE "title" = \'does not exist\' AND "user_id" IN (\'1\', \'2\', \'3\')', $this->connectionManager->connection('sqlite')->getLog()[1]['query']);
SELECT * FROM "foobar" FOR UPDATE WITH LOCK', $query['sql']);
SELECT * FROM `foobar` CUSTOM LOCK', $query['sql']);
SELECT * FROM `foobar` LIMIT 10 OFFSET 10', $query['sql']);
SELECT * FROM "foobar" WITH LOCK', $query['sql']);
SELECT * FROM (SELECT *, ROW_NUMBER() OVER (ORDER BY (SELECT 0)) AS mako_rownum FROM "foobar") AS mako1 WHERE mako_rownum BETWEEN 1 AND 10 FOR UPDATE WITH RS', $query['sql']);
SELECT COUNT(*) FROM "users" WHERE "id" = 0', $this->connectionManager->connection()->getLog()[0]['query']);
SELECT * FROM "foobar" FOR UPDATE WITH RS', $query['sql']);
SELECT * FROM "users" WHERE "id" = \'3\' LIMIT 1', $this->connectionManager->connection('sqlite')->getLog()[3]['query']);
SELECT * FROM "foobar" WHERE "foo" = ? OR "foo" = SUBSTRING("foo", 1, 2)', $query['sql']);
SELECT * FROM "polymorphic_comments" WHERE "commentable_id" = \'3\' AND "commentable_type" = \'\mako\tests\integration\database\midgard\relations\HasManyPolymorphicArticle\'', $this->connectionManager->connection('sqlite')->getLog()[3]['query']);
SELECT * FROM [foobar] ORDER BY (SELECT 0) OFFSET 10 ROWS', $query['sql']);
SELECT * FROM "articles" WHERE "autoeagerloadinguser_id" = \'2\'', $this->connectionManager->connection('sqlite')->getLog()[2]['query']);
SELECT * FROM "foobar" WHERE "id" > ? AND "foo" IN (SELECT id FROM barfoo WHERE id > ?) AND "id" < ?', $query['sql']);
SELECT * FROM "foobar" WHERE "foo" BETWEEN ? AND ? OR "foo" BETWEEN ? AND ?', $query['sql']);
SELECT * FROM (SELECT *, ROW_NUMBER() OVER (ORDER BY (SELECT 0)) AS mako_rownum FROM "foobar") AS mako1 WHERE mako_rownum BETWEEN 11 AND 20', $query['sql']);
SELECT * FROM (SELECT * FROM "foobar") AS "mako0"', $query['sql']);
SELECT * FROM "foobar" WHERE "foo" = ? AND "foo" <> ? AND "foo" < ? AND "foo" <= ? AND "foo" > ? AND "foo" >= ? AND "foo" LIKE ? AND "foo" NOT LIKE ? AND "foo" = bar AND "foo" <> bar AND "foo" < bar AND "foo" <= bar AND "foo" > bar AND "foo" >= bar AND "foo" LIKE bar AND "foo" NOT LIKE bar OR "foo" = ? OR "foo" <> ? OR "foo" < ? OR "foo" <= ? OR "foo" > ? OR "foo" >= ? OR "foo" LIKE ? OR "foo" NOT LIKE ? OR "foo" = bar OR "foo" <> bar OR "foo" < bar OR "foo" <= bar OR "foo" > bar OR "foo" >= bar OR "foo" LIKE bar OR "foo" NOT LIKE bar', $query['sql']);
SELECT * FROM "foobar" WHERE "foo" = SUBSTRING("foo", 1, 2)', $query['sql']);
SELECT * FROM "foobar" WHERE EXISTS (SELECT * FROM "barfoo" WHERE "barfoo"."foobar_id" = foobar.id)', $query['sql']);
SELECT * FROM "foobar" INNER JOIN "barfoo" ON "barfoo"."foobar_id" = SUBSTRING("foo", 1, 2)', $query['sql']);
SELECT * FROM "polymorphic_comments" WHERE "commentable_id" = \'2\' AND "commentable_type" = \'\mako\tests\integration\database\midgard\relations\HasManyPolymorphicArticle\'', $this->connectionManager->connection('sqlite')->getLog()[2]['query']);
SELECT * FROM "users" WHERE "id" = \'1\'', $this->connectionManager->connection('sqlite')->getLog()[1]['query']);
SELECT * FROM "foobar" FOR SHARE', $query['sql']);
SELECT * FROM "foobar" FOR READ ONLY WITH RS', $query['sql']);
SELECT * FROM "foobar" ORDER BY "foo" DESC OFFSET 10 ROWS', $query['sql']);
SELECT * FROM "users" ORDER BY "id" ASC', $this->connectionManager->connection('sqlite')->getLog()[0]['query']);
SELECT * FROM [foobar]', $query['sql']);
SELECT COUNT(*) FROM (SELECT "id", "username" FROM "users" GROUP BY "id", "username") AS "count"', $this->connectionManager->connection()->getLog()[0]['query']);
SELECT * FROM "foobar" ROWS 1 TO 10', $query['sql']);
SELECT * FROM "foobar" WHERE "foo" IS NOT NULL OR "bar" IS NOT NULL', $query['sql']);
SELECT * FROM "profiles" WHERE "id" = 1 LIMIT 1', $this->connectionManager->connection('sqlite')->getLog()[0]['query']);
SELECT * FROM "foobar" WHERE NOT EXISTS (SELECT * FROM "barfoo" WHERE "barfoo"."foobar_id" = foobar.id)', $query['sql']);
SELECT * FROM "images" WHERE "imageable_id" = \'2\' AND "imageable_type" = \'\mako\tests\integration\database\midgard\relations\HasOnePolymorphicProfile\' LIMIT 1', $this->connectionManager->connection('sqlite')->getLog()[2]['query']);
SELECT * FROM "articles" WHERE "user_id" = \'3\'', $this->connectionManager->connection('sqlite')->getLog()[3]['query']);
SELECT * FROM "barfoo" WHERE "id" > 1) AS "barfoo"'), 'barfoo.foobar_id', '=', 'foobar.id');
SELECT * FROM "articles" ORDER BY "id" ASC', $this->connectionManager->connection('sqlite')->getLog()[0]['query']);
SELECT * FROM "foobar" INNER JOIN "barfoo" ON "barfoo"."foobar_id" = "foobar"."id" AND ("barfoo"."foobar_id" = "foobar"."id" OR "barfoo"."foobar_id" != "foobar"."id")', $query['sql']);
SELECT * FROM "images" WHERE "imageable_type" = \'\mako\tests\integration\database\midgard\relations\HasOnePolymorphicProfile\' AND "image" = \'does not exist\' AND "imageable_id" IN (\'1\', \'2\', \'3\')', $this->connectionManager->connection('sqlite')->getLog()[1]['query']);
SELECT id FROM barfoo
SELECT id FROM barfoo WHERE id > ?
SELECT * FROM "article_comments" WHERE "comment" = \'does not exist\' AND "article_id" IN (\'1\', \'2\', \'3\')', $this->connectionManager->connection('sqlite')->getLog()[2]['query']);
SELECT * FROM "article_comments" WHERE "article_id" IN (\'1\', \'2\', \'3\')', $this->connectionManager->connection('sqlite')->getLog()[2]['query']);
SELECT COUNT(*) FROM (SELECT DISTINCT "id", "username" FROM "users") AS "count"', $this->connectionManager->connection()->getLog()[0]['query']);
SELECT * FROM "articles" WHERE "autoeagerloadinguser_id" = \'3\'', $this->connectionManager->connection('sqlite')->getLog()[3]['query']);
SELECT * FROM "foobar" INNER JOIN (SELECT * FROM "barfoo" WHERE "id" > 1) AS "barfoo" ON "barfoo"."foobar_id" = "foobar"."id"', $query['sql']);
