{"datasette": "<datasette.app.Datasette object at 0x3e969bbeb490>", "columns": ["group_concat(query, ' union all ')"], "rows": ["<sqlite3.Row object at 0x3e969afc2380>"], "sql": "with tables as (\r\n  select\r\n    name as table_name\r\n  from\r\n    sqlite_master\r\n  where\r\n    type = 'table'\r\n),\r\nqueries as (\r\n  select\r\n    'select ''' || tables.table_name || ''' as _table, rowid from \"' || tables.table_name || '\" where ' || group_concat(\r\n      '\"' || name || '\" like ''%'' || :search || ''%''',\r\n      ' or '\r\n    ) as query\r\n  from\r\n    pragma_table_info(tables.table_name),\r\n    tables\r\n  group by\r\n    tables.table_name\r\n)\r\nselect\r\n  group_concat(query, ' union all ')\r\nfrom\r\n  queries", "query_name": null, "database": "fixtures", "table": null, "request": "<asgi.Request method=\"GET\" url=\"https://latest.datasette.io/fixtures.testall?sql=with+tables+as+(%0D%0A++select%0D%0A++++name+as+table_name%0D%0A++from%0D%0A++++sqlite_master%0D%0A++where%0D%0A++++type+%3D+'table'%0D%0A)%2C%0D%0Aqueries+as+(%0D%0A++select%0D%0A++++'select+'''+%7C%7C+tables.table_name+%7C%7C+'''+as+_table%2C+rowid+from+%22'+%7C%7C+tables.table_name+%7C%7C+'%22+where+'+%7C%7C+group_concat(%0D%0A++++++'%22'+%7C%7C+name+%7C%7C+'%22+like+''%25''+%7C%7C+%3Asearch+%7C%7C+''%25'''%2C%0D%0A++++++'+or+'%0D%0A++++)+as+query%0D%0A++from%0D%0A++++pragma_table_info(tables.table_name)%2C%0D%0A++++tables%0D%0A++group+by%0D%0A++++tables.table_name%0D%0A)%0D%0Aselect%0D%0A++group_concat(query%2C+'+union+all+')%0D%0Afrom%0D%0A++queries\">", "view_name": "table", "1+1": 2}