{"datasette": "<datasette.app.Datasette object at 0x3e10380f6f10>", "columns": ["addr", "opcode", "p1", "p2", "p3", "p4", "p5", "comment"], "rows": ["<sqlite3.Row object at 0x3e10375d1ed0>", "<sqlite3.Row object at 0x3e1037532d70>", "<sqlite3.Row object at 0x3e1037531180>", "<sqlite3.Row object at 0x3e1037531a50>", "<sqlite3.Row object at 0x3e10375318d0>", "<sqlite3.Row object at 0x3e1037532da0>", "<sqlite3.Row object at 0x3e1037531d20>", "<sqlite3.Row object at 0x3e1037532b00>", "<sqlite3.Row object at 0x3e1037531e40>", "<sqlite3.Row object at 0x3e10375314e0>", "<sqlite3.Row object at 0x3e1037533c70>", "<sqlite3.Row object at 0x3e1037532320>", "<sqlite3.Row object at 0x3e1037530b80>", "<sqlite3.Row object at 0x3e1037533fd0>", "<sqlite3.Row object at 0x3e1037532140>", "<sqlite3.Row object at 0x3e1037531420>", "<sqlite3.Row object at 0x3e1037533220>", "<sqlite3.Row object at 0x3e1037530d00>", "<sqlite3.Row object at 0x3e1037530ca0>", "<sqlite3.Row object at 0x3e1037532fb0>", "<sqlite3.Row object at 0x3e1037533790>", "<sqlite3.Row object at 0x3e1037532170>", "<sqlite3.Row object at 0x3e10375319f0>", "<sqlite3.Row object at 0x3e1037530f40>", "<sqlite3.Row object at 0x3e10375319c0>", "<sqlite3.Row object at 0x3e1037531b70>", "<sqlite3.Row object at 0x3e1037531a20>", "<sqlite3.Row object at 0x3e1037531750>", "<sqlite3.Row object at 0x3e1037533040>", "<sqlite3.Row object at 0x3e1037531db0>", "<sqlite3.Row object at 0x3e1037531720>", "<sqlite3.Row object at 0x3e10375323e0>", "<sqlite3.Row object at 0x3e1037533b80>", "<sqlite3.Row object at 0x3e1037533970>", "<sqlite3.Row object at 0x3e1037532440>", "<sqlite3.Row object at 0x3e10375328c0>", "<sqlite3.Row object at 0x3e1037532f20>", "<sqlite3.Row object at 0x3e1037531f30>", "<sqlite3.Row object at 0x3e1037530a00>", "<sqlite3.Row object at 0x3e1037530d60>", "<sqlite3.Row object at 0x3e1037530eb0>", "<sqlite3.Row object at 0x3e1037533310>", "<sqlite3.Row object at 0x3e10375333d0>", "<sqlite3.Row object at 0x3e1037531600>", "<sqlite3.Row object at 0x3e1037532470>", "<sqlite3.Row object at 0x3e10375332e0>", "<sqlite3.Row object at 0x3e1037533a60>", "<sqlite3.Row object at 0x3e1037533880>", "<sqlite3.Row object at 0x3e10375320b0>", "<sqlite3.Row object at 0x3e1037532a70>", "<sqlite3.Row object at 0x3e1037531b10>", "<sqlite3.Row object at 0x3e10375335e0>", "<sqlite3.Row object at 0x3e1037533670>", "<sqlite3.Row object at 0x3e1037531120>", "<sqlite3.Row object at 0x3e1037533d00>", "<sqlite3.Row object at 0x3e1037532290>", "<sqlite3.Row object at 0x3e1037531540>", "<sqlite3.Row object at 0x3e1037531780>", "<sqlite3.Row object at 0x3e1037531e70>", "<sqlite3.Row object at 0x3e1037530c40>", "<sqlite3.Row object at 0x3e1037532050>", "<sqlite3.Row object at 0x3e1037531450>", "<sqlite3.Row object at 0x3e1037532c20>", "<sqlite3.Row object at 0x3e1037530e80>", "<sqlite3.Row object at 0x3e1037532bf0>", "<sqlite3.Row object at 0x3e1037531f90>", "<sqlite3.Row object at 0x3e1037532cb0>", "<sqlite3.Row object at 0x3e10375339a0>", "<sqlite3.Row object at 0x3e1037510610>", "<sqlite3.Row object at 0x3e1037512b30>", "<sqlite3.Row object at 0x3e1037512050>", "<sqlite3.Row object at 0x3e10375113f0>", "<sqlite3.Row object at 0x3e1037510b20>", "<sqlite3.Row object at 0x3e1037512a70>", "<sqlite3.Row object at 0x3e1037512920>", "<sqlite3.Row object at 0x3e1037511cc0>", "<sqlite3.Row object at 0x3e1037510700>", "<sqlite3.Row object at 0x3e10375127d0>", "<sqlite3.Row object at 0x3e1037512890>", "<sqlite3.Row object at 0x3e10375110f0>", "<sqlite3.Row object at 0x3e1037511090>", "<sqlite3.Row object at 0x3e1037510c10>", "<sqlite3.Row object at 0x3e1037510250>", "<sqlite3.Row object at 0x3e1037511570>", "<sqlite3.Row object at 0x3e1037510940>", "<sqlite3.Row object at 0x3e10375118d0>", "<sqlite3.Row object at 0x3e1037512bc0>", "<sqlite3.Row object at 0x3e10375100a0>", "<sqlite3.Row object at 0x3e10375112a0>", "<sqlite3.Row object at 0x3e10375113c0>", "<sqlite3.Row object at 0x3e1037512b60>", "<sqlite3.Row object at 0x3e10375105e0>", "<sqlite3.Row object at 0x3e1037512aa0>", "<sqlite3.Row object at 0x3e1037511690>", "<sqlite3.Row object at 0x3e1037511720>", "<sqlite3.Row object at 0x3e10375124a0>", "<sqlite3.Row object at 0x3e1037510760>", "<sqlite3.Row object at 0x3e1037512b00>", "<sqlite3.Row object at 0x3e1037511120>", "<sqlite3.Row object at 0x3e1037512770>", "<sqlite3.Row object at 0x3e10375111e0>", "<sqlite3.Row object at 0x3e1037510bb0>", "<sqlite3.Row object at 0x3e1037512b90>", "<sqlite3.Row object at 0x3e10375115d0>", "<sqlite3.Row object at 0x3e1037510d00>", "<sqlite3.Row object at 0x3e1037510ac0>", "<sqlite3.Row object at 0x3e1037510a00>", "<sqlite3.Row object at 0x3e1037510820>", "<sqlite3.Row object at 0x3e1037511060>", "<sqlite3.Row object at 0x3e10375101c0>", "<sqlite3.Row object at 0x3e1037510fd0>", "<sqlite3.Row object at 0x3e1037510f70>", "<sqlite3.Row object at 0x3e1037512c80>", "<sqlite3.Row object at 0x3e1037511f00>", "<sqlite3.Row object at 0x3e1037510ca0>", "<sqlite3.Row object at 0x3e10375119f0>", "<sqlite3.Row object at 0x3e1037533760>", "<sqlite3.Row object at 0x3e1037511000>", "<sqlite3.Row object at 0x3e10375117b0>", "<sqlite3.Row object at 0x3e1037510f40>", "<sqlite3.Row object at 0x3e10375324d0>", "<sqlite3.Row object at 0x3e10375318a0>", "<sqlite3.Row object at 0x3e1037533a30>", "<sqlite3.Row object at 0x3e1037533250>", "<sqlite3.Row object at 0x3e1037533e80>", "<sqlite3.Row object at 0x3e1037531900>", "<sqlite3.Row object at 0x3e1036b70df0>", "<sqlite3.Row object at 0x3e10357915d0>", "<sqlite3.Row object at 0x3e1037512bf0>", "<sqlite3.Row object at 0x3e103578e860>", "<sqlite3.Row object at 0x3e103578cbe0>", "<sqlite3.Row object at 0x3e103578f2b0>", "<sqlite3.Row object at 0x3e1037531fc0>", "<sqlite3.Row object at 0x3e1037531060>", "<sqlite3.Row object at 0x3e1037532ad0>", "<sqlite3.Row object at 0x3e1037532b60>", "<sqlite3.Row object at 0x3e10375322f0>", "<sqlite3.Row object at 0x3e1036b71600>", "<sqlite3.Row object at 0x3e1036b70130>", "<sqlite3.Row object at 0x3e1036b738b0>", "<sqlite3.Row object at 0x3e1036b71d80>", "<sqlite3.Row object at 0x3e1036b72290>", "<sqlite3.Row object at 0x3e1037511420>", "<sqlite3.Row object at 0x3e10375100d0>", "<sqlite3.Row object at 0x3e1037510a90>", "<sqlite3.Row object at 0x3e1037510790>", "<sqlite3.Row object at 0x3e1037512a10>", "<sqlite3.Row object at 0x3e10375114b0>", "<sqlite3.Row object at 0x3e10375128c0>", "<sqlite3.Row object at 0x3e10375124d0>", "<sqlite3.Row object at 0x3e1037510310>", "<sqlite3.Row object at 0x3e1037511030>", "<sqlite3.Row object at 0x3e1037510ee0>", "<sqlite3.Row object at 0x3e1037510d60>", "<sqlite3.Row object at 0x3e1037512560>", "<sqlite3.Row object at 0x3e10375108e0>", "<sqlite3.Row object at 0x3e10375115a0>", "<sqlite3.Row object at 0x3e1037510850>", "<sqlite3.Row object at 0x3e10375121d0>", "<sqlite3.Row object at 0x3e1037510070>", "<sqlite3.Row object at 0x3e1037512410>", "<sqlite3.Row object at 0x3e1037511960>", "<sqlite3.Row object at 0x3e1037511360>", "<sqlite3.Row object at 0x3e1037511e40>", "<sqlite3.Row object at 0x3e1037512320>", "<sqlite3.Row object at 0x3e103610b0d0>", "<sqlite3.Row object at 0x3e1036b285b0>", "<sqlite3.Row object at 0x3e1037511390>", "<sqlite3.Row object at 0x3e10375101f0>", "<sqlite3.Row object at 0x3e10375111b0>", "<sqlite3.Row object at 0x3e10375109a0>", "<sqlite3.Row object at 0x3e10375129b0>", "<sqlite3.Row object at 0x3e1037511ff0>", "<sqlite3.Row object at 0x3e1036b283a0>", "<sqlite3.Row object at 0x3e1037510340>", "<sqlite3.Row object at 0x3e1037512680>", "<sqlite3.Row object at 0x3e1037510430>", "<sqlite3.Row object at 0x3e1037512a40>", "<sqlite3.Row object at 0x3e1037512590>", "<sqlite3.Row object at 0x3e1037510b80>", "<sqlite3.Row object at 0x3e10375107f0>", "<sqlite3.Row object at 0x3e1037510e50>", "<sqlite3.Row object at 0x3e1037511240>", "<sqlite3.Row object at 0x3e1037510880>", "<sqlite3.Row object at 0x3e1037511300>", "<sqlite3.Row object at 0x3e1037512c50>", "<sqlite3.Row object at 0x3e1037510a60>", "<sqlite3.Row object at 0x3e1037511270>", "<sqlite3.Row object at 0x3e1037510130>", "<sqlite3.Row object at 0x3e1037512c20>", "<sqlite3.Row object at 0x3e1037511ae0>", "<sqlite3.Row object at 0x3e1037511210>", "<sqlite3.Row object at 0x3e10375126b0>", "<sqlite3.Row object at 0x3e1037512ad0>", "<sqlite3.Row object at 0x3e1037512620>", "<sqlite3.Row object at 0x3e10375de860>", "<sqlite3.Row object at 0x3e10375dfd90>", "<sqlite3.Row object at 0x3e10375dd930>", "<sqlite3.Row object at 0x3e10375debc0>", "<sqlite3.Row object at 0x3e10375dce80>", "<sqlite3.Row object at 0x3e10375dd030>", "<sqlite3.Row object at 0x3e10375dc5e0>", "<sqlite3.Row object at 0x3e10375df790>", "<sqlite3.Row object at 0x3e10375dee90>", "<sqlite3.Row object at 0x3e10375dec80>", "<sqlite3.Row object at 0x3e10375de500>", "<sqlite3.Row object at 0x3e10375dc0d0>", "<sqlite3.Row object at 0x3e10375df880>", "<sqlite3.Row object at 0x3e10375df970>", "<sqlite3.Row object at 0x3e10375dead0>", "<sqlite3.Row object at 0x3e10375df070>", "<sqlite3.Row object at 0x3e10375df4f0>", "<sqlite3.Row object at 0x3e10375dee30>", "<sqlite3.Row object at 0x3e10375de080>", "<sqlite3.Row object at 0x3e10375dd2a0>", "<sqlite3.Row object at 0x3e10375df430>", "<sqlite3.Row object at 0x3e10375de410>", "<sqlite3.Row object at 0x3e10375df6a0>", "<sqlite3.Row object at 0x3e10375dc760>", "<sqlite3.Row object at 0x3e10375ddbd0>", "<sqlite3.Row object at 0x3e10375deaa0>", "<sqlite3.Row object at 0x3e10375dc520>", "<sqlite3.Row object at 0x3e10375dd420>", "<sqlite3.Row object at 0x3e10375dece0>", "<sqlite3.Row object at 0x3e10375deb00>", "<sqlite3.Row object at 0x3e10375dfee0>", "<sqlite3.Row object at 0x3e10375de3e0>", "<sqlite3.Row object at 0x3e10375df1f0>", "<sqlite3.Row object at 0x3e10375de1d0>"], "sql": "explain WITH RECURSIVE\r\n  xaxis(x) AS (VALUES(-2.0) UNION ALL SELECT x+0.05 FROM xaxis WHERE x<1.2),\r\n  yaxis(y) AS (VALUES(-1.0) UNION ALL SELECT y+0.1 FROM yaxis WHERE y<1.0),\r\n  m(iter, cx, cy, x, y) AS (\r\n    SELECT 0, x, y, 0.0, 0.0 FROM xaxis, yaxis\r\n    UNION ALL\r\n    SELECT iter+1, cx, cy, x*x-y*y + cx, 2.0*x*y + cy FROM m \r\n     WHERE (x*x + y*y) < 4.0 AND iter<28\r\n  ),\r\n  m2(iter, cx, cy) AS (\r\n    SELECT max(iter), cx, cy FROM m GROUP BY cx, cy\r\n  ),\r\n  a(t) AS (\r\n    SELECT group_concat( substr(' .+*#', 1+min(iter/7,4), 1), '') \r\n    FROM m2 GROUP BY cy\r\n  )\r\nSELECT group_concat(rtrim(t),x'0a') FROM a;", "query_name": null, "database": "fixtures", "table": null, "request": "<asgi.Request method=\"GET\" url=\"https://latest.datasette.io/fixtures.testall?sql=explain+WITH+RECURSIVE%0D%0A++xaxis(x)+AS+(VALUES(-2.0)+UNION+ALL+SELECT+x%2B0.05+FROM+xaxis+WHERE+x%3C1.2)%2C%0D%0A++yaxis(y)+AS+(VALUES(-1.0)+UNION+ALL+SELECT+y%2B0.1+FROM+yaxis+WHERE+y%3C1.0)%2C%0D%0A++m(iter%2C+cx%2C+cy%2C+x%2C+y)+AS+(%0D%0A++++SELECT+0%2C+x%2C+y%2C+0.0%2C+0.0+FROM+xaxis%2C+yaxis%0D%0A++++UNION+ALL%0D%0A++++SELECT+iter%2B1%2C+cx%2C+cy%2C+x*x-y*y+%2B+cx%2C+2.0*x*y+%2B+cy+FROM+m+%0D%0A+++++WHERE+(x*x+%2B+y*y)+%3C+4.0+AND+iter%3C28%0D%0A++)%2C%0D%0A++m2(iter%2C+cx%2C+cy)+AS+(%0D%0A++++SELECT+max(iter)%2C+cx%2C+cy+FROM+m+GROUP+BY+cx%2C+cy%0D%0A++)%2C%0D%0A++a(t)+AS+(%0D%0A++++SELECT+group_concat(+substr('+.%2B*%23'%2C+1%2Bmin(iter%2F7%2C4)%2C+1)%2C+'')+%0D%0A++++FROM+m2+GROUP+BY+cy%0D%0A++)%0D%0ASELECT+group_concat(rtrim(t)%2Cx'0a')+FROM+a%3B\">", "view_name": "table", "1+1": 2}