goodybag/mongo-sql — pull request #25 by jrf0110 (2014-01-29 21:17:55+00:00)
Title: Querying on JSON

So the syntax is something like

```sql
select * from users where users.data->'field' = $1
-- Though, I think you might have to do casting...
select * from users where (users.data->'field')::int = $1
```

Maybe:

```javascript
{
type: 'select'
, table: 'users'
, where: {
'data.field': 123
}
}
```

Though that will mess up the current column quoting mechanism as it expects the only thing that has a period is a ```"table"."column"``` setup. Not a ```"table"."column"->'field'``` setup. Hrmm..