30 Commits

Author SHA1 Message Date
François de Metz
704d12e9ba
Add ability to prepend query comments (#5289)
Co-authored-by: Ryan Fink <ryanjfink@gmail.com>
2023-04-14 06:07:05 +02:00
Olivier Cavadenti
8835d22652
Json advanced support (#4859) 2021-12-22 10:47:16 +01:00
Olivier Cavadenti
49e597df85
[CLEAN] Remove duplicate code (#4813) 2021-11-09 09:34:19 +01:00
Olivier Cavadenti
fdad316f01
Allow skip binding in limit and offset (#4811) 2021-11-08 10:49:11 +01:00
Olivier Cavadenti
b97d49b184
Support whereLike and whereILike (#4779) 2021-10-31 19:52:22 +01:00
Olivier Cavadenti
126b84639e
Support for 'is null' in 'order by' (#3667) (#4720) 2021-10-10 22:45:48 +03:00
Jeremy W. Sherman
40576ce430
fix(mssql): Generate valid SQL for withRecursive() [#4514] (#4639) 2021-08-25 09:36:43 +03:00
Jeremy W. Sherman
52950c652b
fix(mssql): columnInfo() support case-sensitive database collations (#4633) 2021-08-21 21:26:54 +03:00
Egor Koldasov
c335fda657
#873 | implement delete with join (#4568) 2021-07-13 09:41:16 +03:00
Tyler Watson
c860b89184
WIP: Replace MSSQL dialect with Tedious.js implementation (#2857)
Co-authored-by: Tyler Watson <tyler@rapidplatform.com.au>
Co-authored-by: Igor Savin <iselwin@gmail.com>
2021-02-08 08:46:35 +02:00
Igor Savin
9c390036db
Move "parameter" out of formatter (#4275) 2021-02-04 15:54:26 +02:00
Igor Savin
2040bd11a4
Move more logic over from formatter (#4273) 2021-02-03 21:17:20 +02:00
Igor Savin
d89c36ae80
Move more code out of formatter (#4270) 2021-02-03 01:13:16 +02:00
martinmacko47
50be910113
Allow optimizer hints (#4243) 2021-01-28 01:57:25 +02:00
Igor Savin
b111771117
Clean up querybuilder (#4220) 2021-01-09 17:59:53 +02:00
Igor Savin
cd6479bf0b
More formatter cleanup (#4218) 2021-01-07 23:34:46 +02:00
Igor Savin
936126c0f0
Add analytic functions v2 (#4188)
Co-authored-by: CorvusCorrax <renaud.cayol@gmail.com>
Co-authored-by: Alexandre Tiertant <alexandre.tiertant@gmail.com>
2020-12-31 14:38:50 +02:00
Kkmatt11
629909475c
Fix MSSQL with returns on inserts and deletes on tables with triggers (#4152) 2020-12-18 01:12:04 +02:00
Nico Burns
8d43019873
Implement "UPSERT" (Postgres/MySQL/Sqlite) (#3763) 2020-10-31 17:22:52 +02:00
Igor Savin
e37aeaa31c
Prepare for 0.21.0 release (#3811) 2020-04-19 00:40:23 +02:00
tkalliom
02d94d96b0
Reduce size of lodash in bundle (#3804) 2020-04-18 19:41:23 +02:00
Lorefnon
589ea747c2
Update QueryCompiler implementation to use classes (#3647) 2020-02-01 17:22:00 +01:00
Lorefnon
f87b28c3e3 Add support for distinct on for postgres (#3513)
Resolves #3472
2019-11-11 00:51:47 +01:00
Lorefnon
3e1a5ee0de Minor enhancements around aliasing of aggregates (#3354)
- Allows an options object to specify alias (as suggested in https://github.com/tgriesser/knex/issues/3315#issuecomment-507439215) (Closes #3315)
- Allows multiple aliases when using object syntax (Closes #2871)
2019-07-16 18:48:28 +02:00
Ricardo Graça
9aa7085b05 Rename src directory to lib (#3338) 2019-07-10 23:48:43 +02:00
Mikael Lepistö
7140a48226 Remove generated lib from repository and run build in prepublish 2016-01-21 09:59:30 +02:00
Sky Morey
eed0004031 mssql: added top (?) back to fix that error. also removed loading of empty file 2015-12-15 16:48:19 -06:00
Sky Morey
ae256f2943 mssql limit and offset for sql2012 2015-12-15 14:56:56 -06:00
Sky Morey
afd6b66624 Final build of mssql provider, all tests pass 2015-12-09 17:53:53 -06:00
Sky Morey
7c1120e0e2 in progress 2015-12-08 11:37:31 -06:00