webpp
webpp copied to clipboard
SQL Query Builder
- [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 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.