sqlkata
join support for update/delete statements
If the database engine supports a delete + join syntax then compile the query, if not, throw an exception.
- [x] SqlServer
- [ ] MySql
- [ ] PostgreSQL
- [ ] Oracle (delete from where exists ? )
- [ ] Other compilers or throw an exception
For MySql we can use this approach https://stackoverflow.com/a/4192849/1104402
@ahmad-moussawi Yes sir, the syntax is pretty much the same as that for SqlServer. I will be testing it against MySql here before committing that one up.
This still being worked on? Can we get some insight on what needs to be done?
I see the SqlServer checkbox is checked. Does that mean it is already available or is in waiting in some PR where other compilers also need to be updated?
is there any progress with the Delete with joins branch from feb? https://github.com/sqlkata/querybuilder/pull/558
