{"action":"created","issue":{"url":"https://api.github.com/repos/feathersjs/feathers-knex/issues/87","repository_url":"https://api.github.com/repos/feathersjs/feathers-knex","labels_url":"https://api.github.com/repos/feathersjs/feathers-knex/issues/87/labels{/name}","comments_url":"https://api.github.com/repos/feathersjs/feathers-knex/issues/87/comments","events_url":"https://api.github.com/repos/feathersjs/feathers-knex/issues/87/events","html_url":"https://github.com/feathersjs/feathers-knex/issues/87","id":191232861,"number":87,"title":"Exposing the query builder","user":{"login":"leebenson","id":719722,"avatar_url":"https://avatars.githubusercontent.com/u/719722?v=3","gravatar_id":"","url":"https://api.github.com/users/leebenson","html_url":"https://github.com/leebenson","followers_url":"https://api.github.com/users/leebenson/followers","following_url":"https://api.github.com/users/leebenson/following{/other_user}","gists_url":"https://api.github.com/users/leebenson/gists{/gist_id}","starred_url":"https://api.github.com/users/leebenson/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/leebenson/subscriptions","organizations_url":"https://api.github.com/users/leebenson/orgs","repos_url":"https://api.github.com/users/leebenson/repos","events_url":"https://api.github.com/users/leebenson/events{/privacy}","received_events_url":"https://api.github.com/users/leebenson/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":3,"created_at":"2016-11-23T10:22:16Z","updated_at":"2016-11-30T18:54:19Z","closed_at":"2016-11-30T18:37:45Z","body":"I'm trying to figure out how to access the query builder object instead of the resolved promise containing row data that's returned by `.find()`.\r\n\r\nI'm using this lib vs. my own 'raw' knex connection to map feathers' query operators, and its handling of pagination, etc. At the same time, I often need more granular access to what's returned in a typical `.find` -- left joins, mapping hasMany relationships, scoping SQL to a transaction, etc.\r\n\r\nIt'd be super handy to have a generic query method that could return the QB instead of the raw results... is there a best practice for doing that?"},"comment":{"url":"https://api.github.com/repos/feathersjs/feathers-knex/issues/comments/263960790","html_url":"https://github.com/feathersjs/feathers-knex/issues/87#issuecomment-263960790","issue_url":"https://api.github.com/repos/feathersjs/feathers-knex/issues/87","id":263960790,"user":{"login":"daffl","id":338316,"avatar_url":"https://avatars.githubusercontent.com/u/338316?v=3","gravatar_id":"","url":"https://api.github.com/users/daffl","html_url":"https://github.com/daffl","followers_url":"https://api.github.com/users/daffl/followers","following_url":"https://api.github.com/users/daffl/following{/other_user}","gists_url":"https://api.github.com/users/daffl/gists{/gist_id}","starred_url":"https://api.github.com/users/daffl/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/daffl/subscriptions","organizations_url":"https://api.github.com/users/daffl/orgs","repos_url":"https://api.github.com/users/daffl/repos","events_url":"https://api.github.com/users/daffl/events{/privacy}","received_events_url":"https://api.github.com/users/daffl/received_events","type":"User","site_admin":false},"created_at":"2016-11-30T18:54:19Z","updated_at":"2016-11-30T18:54:19Z","body":"This is done in 2.6.0. Documentation can be found in https://docs.feathersjs.com/v/auk/databases/knexjs.html#customizing-the-query"}}
{"actor":{"display_login":"daffl"}}