WHERE and other features for SELECT, INSERT, etc.

[Narigo]

Right now, the SELECT and INSERT commands can only construct very simple SQL statements, since we couldn't find a nice library that produces SQL from JSON. Writing our own would be quite complex - if someone knows a good library or wants to volunteer on writing a nicer version, please add pull requests :)

[rowanseymour]

Would be very useful to hear what workarounds people are using until this feature is implemented

[Narigo]

You can always use the "raw" command and write the queries you need.
Am 16.05.2014 08:28 schrieb "Rowan Seymour" [email protected]:

Would be very useful to hear what workarounds people are using until this
feature is implemented

—
Reply to this email directly or view it on GitHubhttps://github.com//issues/1#issuecomment-43301163
.

[rowanseymour]

Yes sorry I did find that but hadn't found a good open source library for simple SQL generation (so I don't have to worry about injection). Have it working nicely with "prepared" now and this https://gist.github.com/agentgt/3650165