planetarydev/json-sql-builder2

Issues

• is there a preexisting sql statement parser into a SQLBuilder object

  #48 opened 2 years ago by ganeshkbhat
  0

• Does it support nested condition in where ?

  #47 opened 2 years ago by sathithyayogi05
  0

• syntax error in readme.md

  #46 opened 2 years ago by sathithyayogi
  0

• Alter Table

  #43 opened 3 years ago by JEMasonMedia
  0

• MySQL | possible to search JSON values

  #33 opened 6 years ago by superhero
  1

• isValidIdent method question

  #29 opened 6 years ago by rojoyin
  2

• Compatibility with MongoDB

  #37 opened 6 years ago by yanickrochon
  2

• Can not order by DESC??

  #38 opened 6 years ago by zzhgithub
  1

• Feature request: add function LAST_INSERT_ID()

  #36 opened 6 years ago by yanickrochon
  1

• Support for UNSIGNED values in $createTable?

  #28 opened 6 years ago by lukesrw
  2

• complex sql handling : case statements, string functions, analytic functions

  #34 opened 6 years ago by ashwinilokhande19
  2

• not able to use trim(), upper(), lower(), etc

  #35 opened 6 years ago by ashwinilokhande19
  1

• how can we add 'and' 'or' and 'not' condition in where clause?

  #32 opened 6 years ago by ankurshah32
  2

• Window functions support

  #31 opened 6 years ago by lagleki
  0

• order by function(value)

  #30 opened 6 years ago by lagleki
  0

• return full query in object

  #16 opened 6 years ago by lagleki
  4

• Using cast function in WHERE clause

  #26 opened 6 years ago by planetarydev
  3

• Select all, with further columns?

  #20 opened 6 years ago by lukesrw
  1

• Division arithmetic helper does not exists

  #23 opened 6 years ago by umer-mehmood
  6

• SyntaxError: Unexpected token ...

  #21 opened 6 years ago by g8up
  0

• $ine broken for $createView

  #18 opened 6 years ago by lukesrw
  2

• $concat broken for SQLite

  #19 opened 6 years ago by lukesrw
  0

• Support for Virtual Column in Select Statement for Postgres

  #17 opened 6 years ago by umer-mehmood
  2

• support subquery expressions

  #15 opened 6 years ago by lagleki
  2

• help: psql function call

  #14 opened 6 years ago by gopalakrishnan-subramani
  2

• sql select returning query which is not runnable in mssql.

  #11 opened 6 years ago by zurez-sgig
  1

• custom functions?

  #12 opened 6 years ago by lagleki
  2

• no such file or directory, scandir '/sql/' issue var sql = new SQLBuilder('SQLServer');

  #9 opened 6 years ago by dhaneshhs
  4

• table alias don't seem to be right for oracle dialect

  #8 opened 6 years ago by belgac
  5

• Operator for cases : lowercase and uppercase

  #7 opened 7 years ago by AlangBert
  1

• Support SQL Server XML modify()

  #6 opened 7 years ago by tvedtorama
  5

• Invalid index on SQL Server params

  #5 opened 7 years ago by tvedtorama
  1

• '$from' rejects multiple source

  #3 opened 7 years ago by hidori
  6

• `new SQLBuilder('MySQL')` Fails on Windows

  #2 opened 7 years ago by em-hshibuki
  3

• Documentation

  #1 opened 8 years ago by ricardo-destemido
  1