255 Commits

Author SHA1 Message Date
ROUL
57419fbbea
Missing comments on delete, update and insert (#5738)
Co-authored-by: Igor Savin <iselwin@gmail.com>
2023-11-28 02:19:51 +02:00
Alex Vershinin
04642dab63
MySQL dialect: added implementation for upsert (#5743)
Co-authored-by: Igor Savin <iselwin@gmail.com>
2023-11-28 02:14:36 +02:00
Warren Seymour
61ee5338b3
feat(pg): implement QueryBuilder#updateFrom (#5386) 2023-07-06 13:31:28 +02:00
Luke Stevens
d96bc191e3
fix: handle numeric array elements in .orderBy() (#5551) 2023-07-04 22:23:01 +02:00
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
Deirdre Sweeney
4d5ae61bfe
[ISSUE-5350] Create EXCEPT as a valid keyword (#5357) 2023-03-29 14:03:59 +02:00
Anton Savchenko
e145322da9
1227: add assertion for basic where clause values (#5417) 2023-01-05 23:27:49 +01:00
Suhyeong Cho
72bd1f7396
Fix: orWhereJson (#5361) 2022-11-18 23:23:52 +01:00
Olivier Cavadenti
c3e41e3d78
Wrapped Unions Fixes (#5072) 2022-03-19 13:05:52 +01:00
Olivier Cavadenti
a906596f06
Rework Union Wrapping (#5030) 2022-03-07 13:45:58 +01:00
Olivier Cavadenti
106a881e20
Add whereLike functions (#5044) 2022-03-01 20:19:35 +01:00
Olivier Cavadenti
47b96344c2
Fix delete joins with PostgreSQL (#5016) 2022-02-09 23:01:43 +01:00
Olivier Cavadenti
ffb60191db
Fix Order nulls in PostgreSQL (#4989) 2022-02-01 10:24:48 +01:00
Olivier Cavadenti
2986f8c1c0
Support string json in json values (#4988) 2022-02-01 00:01:57 +02:00
Lucas Silva
2467db18e9
adding with clause in mysql dialect (#4508)
Co-authored-by: Lucas Silva <lucas.silva@codeminer42.com>
Co-authored-by: Olivier Cavadenti <olivier.cavadenti@gmail.com>
2022-01-25 20:05:19 +01:00
Olivier Cavadenti
6ee3f94d1a
Add raw support in onConflict clause (#4960) 2022-01-22 14:31:51 +01:00
Olivier Cavadenti
63980987a6
Support of MATERIALIZED and NOT MATERIALIZED with WITH/CTE (#4940) 2022-01-20 22:54:03 +01:00
Igor Savin
4a0d82f2be
Fix tests for RETURNING and enable them for SQLite. (#4934) 2022-01-16 02:20:52 +02:00
Beeno Tung
5e6b3c2d6a
remove outdated warning message (#4928)
Co-authored-by: Olivier Cavadenti <olivier.cavadenti@gmail.com>
2022-01-14 22:19:31 +02:00
Olivier Cavadenti
8835d22652
Json advanced support (#4859) 2021-12-22 10:47:16 +01:00
Olivier Cavadenti
de1122ae2f
ForUpdate array parameter (#4882) 2021-12-07 23:44:17 +01:00
Olivier Cavadenti
672c2692b9
Accept Raw on onIn joins (#4830) 2021-11-16 09:25:29 +01:00
Olivier Cavadenti
fdad316f01
Allow skip binding in limit and offset (#4811) 2021-11-08 10:49:11 +01:00
Olivier Cavadenti
ffd0c101f7
Support Joins and Using syntax for PostgreSQL Delete Statement (#4800) 2021-11-07 14:22:49 +01:00
Olivier Cavadenti
75ece731b2
Fix Union all + first syntax error (#4799) 2021-11-03 22:18:27 +01:00
Will Heslam
b7d9a5d927
Fix overzealous warning on use of whereNot with "in" or "between" (#4780) 2021-10-31 19:54:37 +01:00
Olivier Cavadenti
b97d49b184
Support whereLike and whereILike (#4779) 2021-10-31 19:52:22 +01:00
Olivier Cavadenti
d31dc646c5
Support fromRaw (#4781) 2021-10-30 00:40:57 +03:00
Dominik Krejcik
a17cc3214a
Support SELECT .. FOR NO KEY UPDATE / KEY SHARE row level locking clauses in Postgres (#4755) 2021-10-23 16:01:36 +03:00
Olivier Cavadenti
126b84639e
Support for 'is null' in 'order by' (#3667) (#4720) 2021-10-10 22:45:48 +03:00
Igor Savin
941b660f53
Initial infrastructure for CockroachDB (#4571) 2021-10-02 23:45:17 +03:00
Jeremy W. Sherman
a9338208f1
fix(oracledb): withRecursive: omit invalid RECURSIVE keyword, include column list [#4514] (#4652) 2021-09-03 22:27:32 +03:00
wolfcomp
4c79ac1fe6
Fix Analytic orderBy and partitionBy to follow the SQL documentation (#4602) 2021-08-30 20:17:16 +03:00
Jeremy W. Sherman
40576ce430
fix(mssql): Generate valid SQL for withRecursive() [#4514] (#4639) 2021-08-25 09:36:43 +03:00
Egor Koldasov
c335fda657
#873 | implement delete with join (#4568) 2021-07-13 09:41:16 +03:00
Igor Savin
230845d3c2
Make "first" and "pluck" mutually exclusive (#4280) 2021-02-08 13:45:13 +02: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
Ihor Sakailiuk
09e9fa4193
Fix issue with schema usage with FROM clause contain QueryBuilder, function or Raw (#4268) 2021-02-03 19:16:00 +02:00
Ihor Sakailiuk
dbcc8a3228
Fix issue with .withSchema usage with joins on a subquery (#4267) 2021-02-03 00:23:50 +02:00
martinmacko47
50be910113
Allow optimizer hints (#4243) 2021-01-28 01:57:25 +02:00
Igor Savin
a9773b79a3
Extract static methods outside of a formatter (#4213) 2021-01-07 02:04:10 +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
Mark Boyd
76c131e2a9
Add support for WHERE clauses to "upsert" queries (#4148) 2020-12-09 17:51:29 +02:00
Rijk van Zanten
b7e1ffd7d5
Add support for dropForeign in SQLite (#4092)
Co-authored-by: Igor Savin <iselwin@gmail.com>
2020-12-08 14:49:41 +02:00
Nico Burns
8d43019873
Implement "UPSERT" (Postgres/MySQL/Sqlite) (#3763) 2020-10-31 17:22:52 +02:00
Ivan Zhuravlev
5845dc632f
feat(QueryBuilder): add method clear(statement) (#4051) 2020-10-29 01:18:32 +02:00
Simon Lorenz
b65245e1fe
warn if whereNot is used with 'in' or 'between' (#4038)
Co-authored-by: Simon Lorenz <simon.lorenz@stadt-duisburg.de>
2020-09-19 23:45:11 +03:00
Igor Savin
e37aeaa31c
Prepare for 0.21.0 release (#3811) 2020-04-19 00:40:23 +02:00
Edvaldo Szymonek
336b41e148
Add clearGroup method (#3771) 2020-04-13 01:09:51 +02:00
Kabir Baidhya
078b749892
Add unit tests for escape utility functions (#3742) 2020-03-22 18:44:51 +01:00