{"action":"created","issue":{"url":"https://api.github.com/repos/brianc/node-sql/issues/242","labels_url":"https://api.github.com/repos/brianc/node-sql/issues/242/labels{/name}","comments_url":"https://api.github.com/repos/brianc/node-sql/issues/242/comments","events_url":"https://api.github.com/repos/brianc/node-sql/issues/242/events","html_url":"https://github.com/brianc/node-sql/issues/242","id":82229363,"number":242,"title":"SQL support for PostGIS","user":{"login":"nistala","id":4357428,"avatar_url":"https://avatars.githubusercontent.com/u/4357428?v=3","gravatar_id":"","url":"https://api.github.com/users/nistala","html_url":"https://github.com/nistala","followers_url":"https://api.github.com/users/nistala/followers","following_url":"https://api.github.com/users/nistala/following{/other_user}","gists_url":"https://api.github.com/users/nistala/gists{/gist_id}","starred_url":"https://api.github.com/users/nistala/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nistala/subscriptions","organizations_url":"https://api.github.com/users/nistala/orgs","repos_url":"https://api.github.com/users/nistala/repos","events_url":"https://api.github.com/users/nistala/events{/privacy}","received_events_url":"https://api.github.com/users/nistala/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":7,"created_at":"2015-05-29T03:01:02Z","updated_at":"2015-10-12T07:59:19Z","closed_at":null,"body":"PostGIS functions like ST_3DDWithin are not supported right now. Is there any possibility of adding these functions?\r\nhttp://postgis.net/docs/PostGIS_Special_Functions_Index.html"},"comment":{"url":"https://api.github.com/repos/brianc/node-sql/issues/comments/147321721","html_url":"https://github.com/brianc/node-sql/issues/242#issuecomment-147321721","issue_url":"https://api.github.com/repos/brianc/node-sql/issues/242","id":147321721,"user":{"login":"vallettea","id":371303,"avatar_url":"https://avatars.githubusercontent.com/u/371303?v=3","gravatar_id":"","url":"https://api.github.com/users/vallettea","html_url":"https://github.com/vallettea","followers_url":"https://api.github.com/users/vallettea/followers","following_url":"https://api.github.com/users/vallettea/following{/other_user}","gists_url":"https://api.github.com/users/vallettea/gists{/gist_id}","starred_url":"https://api.github.com/users/vallettea/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/vallettea/subscriptions","organizations_url":"https://api.github.com/users/vallettea/orgs","repos_url":"https://api.github.com/users/vallettea/repos","events_url":"https://api.github.com/users/vallettea/events{/privacy}","received_events_url":"https://api.github.com/users/vallettea/received_events","type":"User","site_admin":false},"created_at":"2015-10-12T07:59:19Z","updated_at":"2015-10-12T07:59:19Z","body":"i'm also interested.\r\n@robcalcroft how did you manage in the end ?\r\nmy query  \r\n```\r\n            var query = places\r\n                .select(\r\n                    places.literal(\r\n                        {\r\n                            text: \"SELECT * FROM places WHERE places.geom && ST_MakeEnvelope($1, $2, $3, $4, 4326)\",\r\n                            values: [bbox.minLon, bbox.minLat, bbox.maxLon, bbox.maxLat]\r\n                        }\r\n                    )\r\n                )\r\n                .toQuery();\r\n```\r\n\r\ndoesn't work"}}