{"action":"created","issue":{"url":"https://api.github.com/repos/socrata-platform/soql-reference/issues/33","labels_url":"https://api.github.com/repos/socrata-platform/soql-reference/issues/33/labels{/name}","comments_url":"https://api.github.com/repos/socrata-platform/soql-reference/issues/33/comments","events_url":"https://api.github.com/repos/socrata-platform/soql-reference/issues/33/events","html_url":"https://github.com/socrata-platform/soql-reference/pull/33","id":119790763,"number":33,"title":"Chained selects","user":{"login":"rjmac","id":753700,"avatar_url":"https://avatars.githubusercontent.com/u/753700?v=3","gravatar_id":"","url":"https://api.github.com/users/rjmac","html_url":"https://github.com/rjmac","followers_url":"https://api.github.com/users/rjmac/followers","following_url":"https://api.github.com/users/rjmac/following{/other_user}","gists_url":"https://api.github.com/users/rjmac/gists{/gist_id}","starred_url":"https://api.github.com/users/rjmac/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rjmac/subscriptions","organizations_url":"https://api.github.com/users/rjmac/orgs","repos_url":"https://api.github.com/users/rjmac/repos","events_url":"https://api.github.com/users/rjmac/events{/privacy}","received_events_url":"https://api.github.com/users/rjmac/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"login":"chitang","id":314720,"avatar_url":"https://avatars.githubusercontent.com/u/314720?v=3","gravatar_id":"","url":"https://api.github.com/users/chitang","html_url":"https://github.com/chitang","followers_url":"https://api.github.com/users/chitang/followers","following_url":"https://api.github.com/users/chitang/following{/other_user}","gists_url":"https://api.github.com/users/chitang/gists{/gist_id}","starred_url":"https://api.github.com/users/chitang/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/chitang/subscriptions","organizations_url":"https://api.github.com/users/chitang/orgs","repos_url":"https://api.github.com/users/chitang/repos","events_url":"https://api.github.com/users/chitang/events{/privacy}","received_events_url":"https://api.github.com/users/chitang/received_events","type":"User","site_admin":false},"milestone":null,"comments":18,"created_at":"2015-12-01T19:36:21Z","updated_at":"2015-12-03T22:08:27Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/socrata-platform/soql-reference/pulls/33","html_url":"https://github.com/socrata-platform/soql-reference/pull/33","diff_url":"https://github.com/socrata-platform/soql-reference/pull/33.diff","patch_url":"https://github.com/socrata-platform/soql-reference/pull/33.patch"},"body":"This will let us express queries-on-queries directly in soql, allowing analysis to occur close to the data store, and also allowing queries-on-group-bys as a first-class citizen.\r\n"},"comment":{"url":"https://api.github.com/repos/socrata-platform/soql-reference/issues/comments/161800330","html_url":"https://github.com/socrata-platform/soql-reference/pull/33#issuecomment-161800330","issue_url":"https://api.github.com/repos/socrata-platform/soql-reference/issues/33","id":161800330,"user":{"login":"znep","id":556719,"avatar_url":"https://avatars.githubusercontent.com/u/556719?v=3","gravatar_id":"","url":"https://api.github.com/users/znep","html_url":"https://github.com/znep","followers_url":"https://api.github.com/users/znep/followers","following_url":"https://api.github.com/users/znep/following{/other_user}","gists_url":"https://api.github.com/users/znep/gists{/gist_id}","starred_url":"https://api.github.com/users/znep/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/znep/subscriptions","organizations_url":"https://api.github.com/users/znep/orgs","repos_url":"https://api.github.com/users/znep/repos","events_url":"https://api.github.com/users/znep/events{/privacy}","received_events_url":"https://api.github.com/users/znep/received_events","type":"User","site_admin":false},"created_at":"2015-12-03T22:08:27Z","updated_at":"2015-12-03T22:08:27Z","body":"Yeah... the FROM syntax is much more human friendly and understandable.\n\nOn Wed, Dec 2, 2015 at 11:20 AM, Chris Metcalf <notifications@github.com>\nwrote:\n\n> I'm leaning in the from direction, but then again I strangely find that a\n> good portion of the developers that end up in my support queue actually\n> don't know SQL, so they won't have a preconceived notion there.\n>\n> But yeah, still leaning from.\n>\n> —\n> Reply to this email directly or view it on GitHub\n> <https://github.com/socrata-platform/soql-reference/pull/33#issuecomment-161404155>\n> .\n>\n"}}