{"action":"closed","issue":{"url":"https://api.github.com/repos/tgriesser/knex/issues/1622","repository_url":"https://api.github.com/repos/tgriesser/knex","labels_url":"https://api.github.com/repos/tgriesser/knex/issues/1622/labels{/name}","comments_url":"https://api.github.com/repos/tgriesser/knex/issues/1622/comments","events_url":"https://api.github.com/repos/tgriesser/knex/issues/1622/events","html_url":"https://github.com/tgriesser/knex/issues/1622","id":170595878,"number":1622,"title":"Can I translate knex('acount').where('status', 'active')  into  SQL 'status = 1' ?","user":{"login":"k7","id":1393849,"avatar_url":"https://avatars.githubusercontent.com/u/1393849?v=3","gravatar_id":"","url":"https://api.github.com/users/k7","html_url":"https://github.com/k7","followers_url":"https://api.github.com/users/k7/followers","following_url":"https://api.github.com/users/k7/following{/other_user}","gists_url":"https://api.github.com/users/k7/gists{/gist_id}","starred_url":"https://api.github.com/users/k7/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/k7/subscriptions","organizations_url":"https://api.github.com/users/k7/orgs","repos_url":"https://api.github.com/users/k7/repos","events_url":"https://api.github.com/users/k7/events{/privacy}","received_events_url":"https://api.github.com/users/k7/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":2,"created_at":"2016-08-11T08:40:19Z","updated_at":"2016-08-31T15:04:45Z","closed_at":"2016-08-31T15:04:44Z","body":"Thank you for your time.\r\n\r\nIn my project, I want to hide the plain meaningless number in SQL from higher layer module.\r\n\r\nfor example,  in my account table, `status = 1` means that the account is active.\r\n\r\nbut I want to query it in the higher layer module, just use  \r\n```javascript\r\nknex('acount').where('status', 'active')\r\n```\r\nand it should translate to SQL \r\n```SQL\r\nselect * from acount where status = 1;\r\n```\r\n\r\nHow can I do this?\r\n\r\nThank you very much again!\r\n"}}
{"actor":{"display_login":"elhigu"}}