json-sql-builder2
json-sql-builder2 copied to clipboard
planetarydev
Level Up Your SQL-Queries
I am writing a database library for many basic functions for many database types. I found your library and it coincides a lot with my own methodology concerning query generation....
Quick question, do you support a mysql query like this: `select * from event where `data`->"$.foo" = 'bar'` --- The data column is of type JSON, I tried a few...
What is the state of this project regarding supporting MongoDB features? This is by far the most comprehensive project I have seen offering a somewhat compatible syntax, and I'd be...
Is there any support, or planned support for unsigned values currently? I've searched through the code and I'm not finding any implementation.
Hi, I am trying to use trim, upper, lower functions, but am unable to. getting errors as: The Helper or Operator with the name '$trim' is not defined The Helper...
how can I achieve `select name from foo order by upper(name);`? I can only find `select upper(name) as uname, name from foo order by uname;` but it overloads `select`.
`exists` is probably the most common * https://www.postgresql.org/docs/11/functions-subquery.html Superficially looks like a function. Any hints on crossdialect syntax?
I'm trying to do a: ```sql UPDATE ball SET [cmdList].modify('insert 1030 into (/cmdList)[1]'), ogga.modify('insert 30 into (/ogga)[1]') WHERE [ballId] = @param3" ``` Or actually, I wanted the inserts to be...
promising library. is there a preexisting sql statement or .sql file parser into a SQLBuilder object? How do I do it? A builder without a preexisting parser may be a...
