webpp icon indicating copy to clipboard operation
webpp copied to clipboard

SQL Query Builder

Open the-moisrex opened this issue 3 years ago • 1 comments

  • [x] db.tables: create a query builder object and set the table name.
  • [ ] #151
  • [x] qb.insert
  • [x] qb.insert_default
  • [ ] qb.insert(sub_query): #146
  • [x] qb.select
  • [ ] qb.from('one', 'two', 'more'): do we need this?
  • [x] qb.table(one', 'two', 'more')
  • [x] qb.join
  • [ ] join_on member functions
  • [ ] qb.commit: commit the changes
  • [ ] qb.~dtor: commit
  • [ ] qb.first: get + .first
  • [x] #150
  • [x] qb.del: delete
  • [ ] qb.having
  • [ ] qb.group_by
  • [ ] qb.order_by
  • [ ] blob support
  • [ ] JSON support (SQL 2016)
  • [ ] SELECT DISTINCT
  • [ ] SELECT ALL
  • [ ] WINDOW

the-moisrex avatar Aug 05 '22 17:08 the-moisrex

The expression syntax has got me changing my code based on it. I just hope I don't get in trouble implementing the same things for other sql databases like mysql and sql server after this.

the-moisrex avatar Aug 29 '22 01:08 the-moisrex