Implement new /content.json?sql=...

[simonw]

This will be the base that the remaining work builds on top of. Refs:

• Plan for getting the new JSON format query views working #2109

[simonw]

To avoid confusion I'll start by having /content return a HTML "TODO: implement this" message.

[simonw]

I just noticed that this URL: https://latest.datasette.io/fixtures.csv

Returns a 500 error right now!

It's fine with a ?sql= query: https://latest.datasette.io/fixtures.csv?sql=select+*+from+facetable

[simonw]

I implemented /content and /content.json but I left /content?sql=... as this:

datasette/datasette/views/database.py

Lines 220 to 221 in 2e40a50

	async def query_view(request, datasette, sql):
	return Response.html("Not yet implemented")

[simonw]

Shipped: https://latest.datasette.io/_memory.json?sql=select+sqlite_version()

{
  "rows": [
    {
      "sqlite_version()": "3.34.1"
    }
  ],
  "columns": [
    "sqlite_version()"
  ],
  "ok": true,
  "truncated": false
}