issue_comments: 392343690
This data as json
| html_url | issue_url | id | node_id | user | created_at | updated_at | author_association | body | reactions | issue | performed_via_github_app |
|---|---|---|---|---|---|---|---|---|---|---|---|
| https://github.com/simonw/datasette/issues/292#issuecomment-392343690 | https://api.github.com/repos/simonw/datasette/issues/292 | 392343690 | MDEyOklzc3VlQ29tbWVudDM5MjM0MzY5MA== | 9599 | 2018-05-27T16:08:25Z | 2018-05-27T16:08:40Z | OWNER | Turns out it's actually possible to pull data from other tables using the mechanism in the prototype: ``` { "databases": { "wtr": { "tables": { "license": { "column_selects": { "count": "(select count(*) from license_frequency where license_frequency.license = license.id)" } } } } } } ``` Performance using this technique is pretty terrible though:  | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | 326800219 |