Sean Corfield
|
9b611bb7ff
|
document :not-in
Signed-off-by: Sean Corfield <sean@corfield.org>
|
2024-02-01 10:53:00 -08:00 |
|
Sean Corfield
|
d64177bde5
|
fix MS SQL table hints in FROM clause (e.g. NOLOCK) #522
Signed-off-by: Sean Corfield <sean@corfield.org>
|
2024-01-14 14:48:39 -08:00 |
|
Sean Corfield
|
9b9ec47bcf
|
fix #520
Signed-off-by: Sean Corfield <sean@corfield.org>
|
2024-01-06 12:38:11 -08:00 |
|
Sean Corfield
|
2e34a9f4ea
|
fix #518
Signed-off-by: Sean Corfield <sean@corfield.org>
|
2024-01-06 11:38:45 -08:00 |
|
Hannu Hartikainen
|
45d1230102
|
Add documentation for create-index
|
2023-12-08 13:25:10 +02:00 |
|
Sean Corfield
|
9c40ff4879
|
prep for 2.5.1103
|
2023-12-03 17:24:23 -08:00 |
|
Sean Corfield
|
1e44f82eb5
|
fix #515 by adding :quoted-always option
|
2023-12-03 16:50:16 -08:00 |
|
Sean Corfield
|
9da2ccc812
|
fix #513 with :ignored-metadata option
|
2023-12-02 11:47:43 -08:00 |
|
Sean Corfield
|
18fcddfc34
|
fix 2.5.1091 release
|
2023-10-28 15:31:55 -07:00 |
|
Sean Corfield
|
1fe526a734
|
prep for 2.5.1090
|
2023-10-28 14:04:35 -07:00 |
|
Sean Corfield
|
737baa9d0e
|
fix #512 by supporting array subquery
also adds metadata support for select to produce as struct (or distinct)
|
2023-10-28 13:39:26 -07:00 |
|
Sean Corfield
|
e36ad64aa6
|
#510 document nrql dialect
|
2023-10-21 16:17:28 -07:00 |
|
Sean Corfield
|
caca08fd5b
|
#511 add tests; document bigquery create or replace
|
2023-10-21 14:51:13 -07:00 |
|
Sean Corfield
|
0115424167
|
prep for 2.4.1078
|
2023-10-07 12:23:12 -07:00 |
|
Sean Corfield
|
7fc411bdd7
|
address #507: document change in cast formatting
change of behavior was in december 2022 (2.4.962).
|
2023-10-03 12:21:32 -07:00 |
|
Sean Corfield
|
a6a69a16f7
|
#503 fix example
|
2023-09-16 11:43:08 -07:00 |
|
Sean Corfield
|
756ed95b43
|
fix #503 by adding at time zone special syntax
|
2023-09-16 11:34:05 -07:00 |
|
Sean Corfield
|
ac09fc1abd
|
add distinct/expr clauses
|
2023-09-08 22:28:25 -07:00 |
|
Sean Corfield
|
75830df509
|
address #504 by adding ignore/respect null support
|
2023-09-08 21:55:24 -07:00 |
|
Sean Corfield
|
654a1cb67a
|
prep for 2.4.1066
|
2023-08-27 10:18:49 -07:00 |
|
Sean Corfield
|
87f3e731b1
|
docs for #496
|
2023-08-27 09:53:28 -07:00 |
|
Sean Corfield
|
44ffd340f5
|
fix #501 by making insert/columns/values talk to each other
|
2023-08-26 16:20:32 -07:00 |
|
Sean Corfield
|
1d6ae7b376
|
fix #407 by adding temporal clause support
|
2023-08-26 14:39:15 -07:00 |
|
Sean Corfield
|
810e95fe11
|
fix #389 by showing ONLY(table) examples
|
2023-08-26 12:48:35 -07:00 |
|
Sean Corfield
|
686cbf7272
|
fix #497 by adding tests and documenting :alias
|
2023-08-26 12:31:38 -07:00 |
|
Sean Corfield
|
664e5e2644
|
add create or replace view for postgresql
|
2023-08-23 12:45:19 -07:00 |
|
Sean Corfield
|
ba336f2884
|
clarify :values clause behavior with columns
also add more examples to the RCF at the bottom of honey.sql.
|
2023-08-10 19:31:17 -07:00 |
|
Sean Corfield
|
c2088bff6c
|
prep for 2.4.1045
|
2023-06-25 15:53:04 -07:00 |
|
Sean Corfield
|
290537c581
|
fix #494 by supporting expressions in on conflict
|
2023-06-20 12:11:00 -07:00 |
|
Sean Corfield
|
19e73a3ebd
|
fix #493 by clarifying with values
|
2023-06-10 19:18:36 -07:00 |
|
Sean Corfield
|
445f66ae1e
|
fix #489
|
2023-06-10 19:12:15 -07:00 |
|
Sean Corfield
|
6ce63cad2c
|
prep for 2.4.1033
|
2023-05-22 16:02:59 -07:00 |
|
Sean Corfield
|
077fc3f23a
|
prep for 2.4.1026
|
2023-04-15 15:35:15 -07:00 |
|
Sean Corfield
|
bc66ec5aee
|
fix #485 by adding :with-ordinality operator
|
2023-04-15 11:37:20 -07:00 |
|
Sean Corfield
|
1710e07231
|
fix #486 by support ansi/postgresl interval
|
2023-04-13 22:46:37 -07:00 |
|
Sean Corfield
|
2efe05def2
|
fix #484 by adding TABLE to TRUNCAT
|
2023-04-10 14:09:28 -07:00 |
|
Sean Corfield
|
8cbb7f3834
|
address #483 by adding tests & docs for :join
|
2023-04-07 11:42:39 -07:00 |
|
Sean Corfield
|
025e445d5d
|
prep for 2.4.1011
|
2023-03-23 20:55:12 -07:00 |
|
Sean Corfield
|
522849381d
|
fix #448 by adding database-specific hints and tips
including sqlite :)
|
2023-03-23 20:49:34 -07:00 |
|
Sean Corfield
|
f5744d4f21
|
fix #480 by adding notes about DSL clause to/from helper mapping
|
2023-03-23 19:29:09 -07:00 |
|
Sean Corfield
|
7e67caaf0c
|
fix #481 by adding more examples
|
2023-03-23 19:22:59 -07:00 |
|
Sean Corfield
|
ece9be3a4b
|
prep for 2.4.1006
|
2023-03-17 15:38:08 -07:00 |
|
Sean Corfield
|
bfc8ad6821
|
prep for 2.4.1002
|
2023-03-03 15:57:05 -08:00 |
|
Sean Corfield
|
7e35cb31bf
|
fix #462 by adding precedence caveat to docs
|
2023-03-03 15:52:52 -08:00 |
|
Sean Corfield
|
1d7237884d
|
fix #471 by documenting SQL kws in fn call args
|
2023-03-03 15:42:04 -08:00 |
|
Sean Corfield
|
3c65999ef1
|
fix #474 by documenting dot-selection
and adding support for two levels of field/column selection
|
2023-03-03 15:26:22 -08:00 |
|
Nigel Harsch (Vallen)
|
4b5e4e862b
|
refs #463 - document dialect + quoted = nil behavior
|
2023-03-03 09:37:20 -08:00 |
|
Eugene Pakhomov
|
0c7642a357
|
Add optional type argument to the :array special
|
2023-02-28 02:04:05 +02:00 |
|
Sean Corfield
|
de0adf56ef
|
fixes #461; prep for 2.4.980
|
2023-02-15 22:10:45 -08:00 |
|
Sean Corfield
|
0a6f645d91
|
prep for 2.4.979
|
2023-02-11 13:39:18 -08:00 |
|
Sean Corfield
|
762252b660
|
fixes #459 by making all operators variadic
except for := and the various :<> variants
some operators only make sense in binary usage and will produce invalid
SQL if used in a non-binary manner
|
2023-02-11 13:35:55 -08:00 |
|
Sean Corfield
|
6324eca4fc
|
fixes #459 by making all operators variadic
except for := and the various :<> variants
some operators only make sense in binary usage and will produce invalid
SQL if used in a non-binary manner
|
2023-02-11 13:34:39 -08:00 |
|
Cam Saul
|
982ebd18e1
|
Update differences-from-1-x.md
|
2023-02-08 11:09:14 -08:00 |
|
Cam Saul
|
e783362c6a
|
Add section about ORDER BY ... NULLS LAST to 1.x differences dox
|
2023-02-08 18:56:23 +00:00 |
|
Sean Corfield
|
ca78c7eed4
|
prep for 2.4.972
|
2023-02-02 10:35:23 -08:00 |
|
Sean Corfield
|
22f259e897
|
prep for 2.4.969
|
2023-01-14 16:00:22 -08:00 |
|
Sean Corfield
|
6bdc262e7c
|
close #452 - support :replace-into in all dialects
|
2023-01-14 15:27:42 -08:00 |
|
Sean Corfield
|
6b015400ed
|
fix #445 #453
|
2023-01-14 14:58:13 -08:00 |
|
Sean Corfield
|
56823b8888
|
prep for 2.4.962
|
2022-12-17 16:18:19 -08:00 |
|
Sean Corfield
|
bf96f034c3
|
update docs; fix set-options!
|
2022-12-17 16:02:02 -08:00 |
|
Sean Corfield
|
6e5e1b100d
|
fix #433 #432 by smithing the docs
|
2022-11-20 04:49:31 -08:00 |
|
Youngil Choi
|
a87fa0c9ab
|
Improve type formatting logic in :cast function
|
2022-11-20 06:51:43 +09:00 |
|
Sean Corfield
|
fd64353f41
|
prep for 2.4.947
|
2022-11-05 17:24:15 -07:00 |
|
Sean Corfield
|
95e50a930e
|
fixes #386 #437 #439
|
2022-11-05 17:15:32 -07:00 |
|
Sean Corfield
|
e8ea9283cc
|
fix Support full TRUNCATE syntax (cascade, identity) #438
|
2022-11-04 23:40:30 -07:00 |
|
Sean Corfield
|
dda3aa017e
|
Merge branch 'develop' of github.com:seancorfield/honeysql into develop
|
2022-10-01 00:31:25 -07:00 |
|
Sean Corfield
|
6c107b7cf0
|
fix #435 by documenting CREATE TEMP TABLE etc
|
2022-10-01 00:31:20 -07:00 |
|
Ike Mawira
|
73d36ab2b5
|
Update docs and tests for WITH clause
|
2022-09-23 16:54:30 +03:00 |
|
Sean Corfield
|
5d7a3faea5
|
address #415 by supporting multiple drop columns
|
2022-09-12 13:51:54 -07:00 |
|
Sean Corfield
|
fb601c90d9
|
fix #430 by clarifying the additional escape hatch semantics
|
2022-09-12 12:45:50 -07:00 |
|
Sean Corfield
|
a2571ef312
|
close #427 by documenting the new function
|
2022-09-11 19:43:13 -07:00 |
|
Sean Corfield
|
723b134e90
|
fix set-dialect! reset and document it
|
2022-09-11 15:09:12 -07:00 |
|
Sean Corfield
|
23be700b7e
|
prep for 2.3.928
|
2022-09-03 21:39:37 -07:00 |
|
Sean Corfield
|
2f1d3ae870
|
fixes #421 replace into
|
2022-09-03 21:34:09 -07:00 |
|
Sean Corfield
|
d0e0badf2c
|
add/update docs for #422 #423
|
2022-09-03 21:07:06 -07:00 |
|
Sean Corfield
|
737699c11a
|
fix #425 by clarifying MySQL vs PostgreSQL
|
2022-09-01 22:23:33 -07:00 |
|
Sean Corfield
|
e204f3b45e
|
add security notes about quoting
also consistently use SQL entity names instead of identifiers so the
documentation is consistent in terminology.
|
2022-08-23 17:18:00 -07:00 |
|
Sean Corfield
|
99e955f420
|
fix #419 by adding InlineValue protocol
|
2022-08-06 21:49:49 -07:00 |
|
Sean Corfield
|
e6654f7a22
|
check for empty where clauses fix #413
|
2022-08-06 21:11:08 -07:00 |
|
Sean Corfield
|
061edc42f7
|
prep for 2.3.911
|
2022-07-29 18:27:02 -07:00 |
|
Sean Corfield
|
f0ada59fff
|
fix #406
|
2022-07-29 15:41:04 -07:00 |
|
Sean Corfield
|
5f54fab989
|
document Differences between IN queries between v1 and v2 #418
|
2022-07-28 19:56:52 -07:00 |
|
Sean Corfield
|
8e72cb8f2c
|
fixes #414
|
2022-07-15 11:13:15 -07:00 |
|
Sean Corfield
|
3def127276
|
address #412 by completing options docs
|
2022-07-05 22:41:25 -07:00 |
|
Sean Corfield
|
ab0a3eebae
|
the first part of #412
|
2022-06-27 21:17:54 -07:00 |
|
Sean Corfield
|
5fe73c75bc
|
Support custom dialects fixes #401 (add docs/tests)
|
2022-05-01 17:34:31 -07:00 |
|
Sean Corfield
|
796c734cba
|
prep for 2.2.891 release
|
2022-04-23 16:11:52 -07:00 |
|
Sean Corfield
|
270b9439c8
|
attempting to cache SQL that contains IN () will throw fixes #396
|
2022-04-23 15:54:24 -07:00 |
|
Sean Corfield
|
03275b1035
|
add caveat for caching about #396
|
2022-04-23 15:45:35 -07:00 |
|
Sean Corfield
|
fdc70c67a9
|
fix typo in example
|
2022-04-23 15:45:10 -07:00 |
|
Sean Corfield
|
e45ea8586e
|
Add PostgreSQL JSON / regex operators fixes #398
|
2022-04-23 15:40:47 -07:00 |
|
Sean Corfield
|
13a8aa11b2
|
skip the example that throws
|
2022-04-23 14:11:19 -07:00 |
|
Sean Corfield
|
7f8b7a79b1
|
addresses #403: improve error message; improve docs
|
2022-04-23 13:40:34 -07:00 |
|
Sean Corfield
|
9e72587bf3
|
Document special array constructor for PostgreSQL fixes #404
|
2022-04-23 13:21:07 -07:00 |
|
Sean Corfield
|
314f497417
|
fix #400 by adding :table clause
|
2022-03-26 16:58:28 -07:00 |
|
Sean Corfield
|
ab7c235329
|
fix #399 by correcting docs and tests
|
2022-03-26 13:45:43 -07:00 |
|
Sean Corfield
|
beedc35a22
|
prep for 2.2.868
|
2022-02-21 20:28:07 -08:00 |
|
Sean Corfield
|
1d22086fce
|
fix #381 by adding generic helpers; prep for 2.2.861
|
2022-01-30 22:31:37 -08:00 |
|
Sean Corfield
|
8a2f447676
|
Fix #382 by adding :case-expr syntax
|
2022-01-29 17:19:17 -08:00 |
|
Sean Corfield
|
30209b6cc7
|
prep for 2.2.858
|
2022-01-20 13:09:47 -08:00 |
|