{"datasette": "<datasette.app.Datasette object at 0x3e7d9e787790>", "columns": ["query"], "rows": ["<sqlite3.Row object at 0x3e7d9e603b50>"], "sql": "select 'select\r\n' || group_concat('    case when [' || name || '] is not null then ' || quote(name || ', ') || ' else '''' end', ' ||\r\n') || '\r\n  as columns,\r\n  count(*) as num_rows\r\nfrom\r\n  [' || :table || ']\r\ngroup by\r\n  columns\r\norder by\r\n  num_rows desc' as query from pragma_table_info(:table)", "query_name": null, "database": "fixtures", "table": null, "request": "<asgi.Request method=\"GET\" url=\"https://latest.datasette.io/fixtures.testall?sql=select+'select%0D%0A'+%7C%7C+group_concat('++++case+when+%5B'+%7C%7C+name+%7C%7C+'%5D+is+not+null+then+'+%7C%7C+quote(name+%7C%7C+'%2C+')+%7C%7C+'+else+''''+end'%2C+'+%7C%7C%0D%0A')+%7C%7C+'%0D%0A++as+columns%2C%0D%0A++count(*)+as+num_rows%0D%0Afrom%0D%0A++%5B'+%7C%7C+%3Atable+%7C%7C+'%5D%0D%0Agroup+by%0D%0A++columns%0D%0Aorder+by%0D%0A++num_rows+desc'+as+query+from+pragma_table_info(%3Atable)&table=facetable\">", "view_name": "table", "1+1": 2}