{"action":"created","issue":{"url":"https://api.github.com/repos/npgsql/npgsql/issues/767","labels_url":"https://api.github.com/repos/npgsql/npgsql/issues/767/labels{/name}","comments_url":"https://api.github.com/repos/npgsql/npgsql/issues/767/comments","events_url":"https://api.github.com/repos/npgsql/npgsql/issues/767/events","html_url":"https://github.com/npgsql/npgsql/issues/767","id":105267414,"number":767,"title":"Look into cross apply and lateral join","user":{"login":"roji","id":1862641,"avatar_url":"https://avatars.githubusercontent.com/u/1862641?v=3","gravatar_id":"","url":"https://api.github.com/users/roji","html_url":"https://github.com/roji","followers_url":"https://api.github.com/users/roji/followers","following_url":"https://api.github.com/users/roji/following{/other_user}","gists_url":"https://api.github.com/users/roji/gists{/gist_id}","starred_url":"https://api.github.com/users/roji/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/roji/subscriptions","organizations_url":"https://api.github.com/users/roji/orgs","repos_url":"https://api.github.com/users/roji/repos","events_url":"https://api.github.com/users/roji/events{/privacy}","received_events_url":"https://api.github.com/users/roji/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/npgsql/npgsql/labels/ef7","name":"ef7","color":"eb6420"},{"url":"https://api.github.com/repos/npgsql/npgsql/labels/feature","name":"feature","color":"009800"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2015-09-07T21:08:33Z","updated_at":"2015-09-08T13:10:10Z","closed_at":null,"body":"EF7's RelationalQueryCompilationContext has a `IsCrossApplySupported` property. Cross apply isn't supported by PostgreSQL but lateral joins are. There might be something to do here.\r\n\r\nNote that lateral joins are only supported from PG 9.3 so this will have to be an opt-in/opt-out feature."},"comment":{"url":"https://api.github.com/repos/npgsql/npgsql/issues/comments/138554919","html_url":"https://github.com/npgsql/npgsql/issues/767#issuecomment-138554919","issue_url":"https://api.github.com/repos/npgsql/npgsql/issues/767","id":138554919,"user":{"login":"roji","id":1862641,"avatar_url":"https://avatars.githubusercontent.com/u/1862641?v=3","gravatar_id":"","url":"https://api.github.com/users/roji","html_url":"https://github.com/roji","followers_url":"https://api.github.com/users/roji/followers","following_url":"https://api.github.com/users/roji/following{/other_user}","gists_url":"https://api.github.com/users/roji/gists{/gist_id}","starred_url":"https://api.github.com/users/roji/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/roji/subscriptions","organizations_url":"https://api.github.com/users/roji/orgs","repos_url":"https://api.github.com/users/roji/repos","events_url":"https://api.github.com/users/roji/events{/privacy}","received_events_url":"https://api.github.com/users/roji/received_events","type":"User","site_admin":false},"created_at":"2015-09-08T13:10:10Z","updated_at":"2015-09-08T13:10:10Z","body":"OK thanks, I'll look deeper and maybe send them a PR."}}