187 Commits

Author	SHA1	Message	Date
Flamur Kasa	0a29f6c5d0	fix andWhereNotJsonObject calling wrong function (#5683)	2023-11-28 17:19:19 +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	b5dbe01363	Stringify json value in update (#5063)	2022-03-15 10:47:43 +01:00
Olivier Cavadenti	a906596f06	Rework Union Wrapping (#5030)	2022-03-07 13:45:58 +01:00
Olivier Cavadenti	e0a6e54141	Subquery in on clause missing parenthesis (#5049)	2022-03-04 18:21:35 +01:00
Olivier Cavadenti	106a881e20	Add whereLike functions (#5044)	2022-03-01 20:19:35 +01:00
Olivier Cavadenti	600d3c3755	Fix orWhereJsonPath clause (#5022)	2022-02-13 15:11:39 +01:00
John Hiesey	d956aecc23	Add withMaterialized and withNotMaterialized to method-constants (#5009)	2022-02-07 23:18:35 +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
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
Olivier Cavadenti	8835d22652	Json advanced support (#4859)	2021-12-22 10:47:16 +01:00
Ferris	bb7de096dc	Add CI support for Oracle 18c (resolves #4888) (#4889) ... Co-authored-by: Olivier Cavadenti <olivier.cavadenti@gmail.com>	2021-12-15 14:57:23 +02: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	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	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
Ivan Zhuravlev	6840d3f75b	feat(cockroachdb): add support upsert (#4767) ... Co-authored-by: Igor Savin <iselwin@gmail.com>	2021-10-24 16:27:08 +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
Igor Savin	bfdece3cdc	Process passed Oracle connection (#4757)	2021-10-20 23:35:51 +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
Egor Koldasov	c335fda657	#873 | implement delete with join (#4568)	2021-07-13 09:41:16 +03:00
Minh Son Nguyen	228b49f4af	[Typing] Add types for analytic functions (#4544)	2021-06-29 16:36:02 +03:00
Ardeshir81	6b420cebdf	Throw an error if negative offset is provided (#4361)	2021-03-25 11:30:25 +02:00
Igor Savin	511ea2be0f	Querybuilder cleanup (#4282)	2021-02-08 16:54:00 +02:00
Igor Savin	230845d3c2	Make "first" and "pluck" mutually exclusive (#4280)	2021-02-08 13:45:13 +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
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
Igor Savin	d89c36ae80	Move more code out of formatter (#4270)	2021-02-03 01:13:16 +02:00
Ihor Sakailiuk	dbcc8a3228	Fix issue with .withSchema usage with joins on a subquery (#4267)	2021-02-03 00:23:50 +02:00
maximelkin	b9fb5992b5	Migrate to classes (#4253)	2021-01-31 12:40:13 +02:00
martinmacko47	50be910113	Allow optimizer hints (#4243)	2021-01-28 01:57:25 +02:00
Igor Savin	405b639c0c	Clean up querybuilder (#4222)	2021-01-11 00:38:15 +02:00
Igor Savin	b111771117	Clean up querybuilder (#4220)	2021-01-09 17:59:53 +02:00
Igor Savin	a889a09060	Extract even more formatter stuff into client (#4219)	2021-01-09 17:40:30 +02:00