honeysql-postgres
honeysql-postgres copied to clipboard
nilenso
PostgreSQL extension for honeysql
Hi! It would be nice to support https://www.postgresql.org/docs/9.1/sql-explain.html OOTB. I think that `EXPLAIN` doesn't belong to the SQL [standard](https://ronsavage.github.io/SQL/sql-92.bnf.html) to this would be an extension to honeysql. Cheers - V
Resolves issue: https://github.com/nilenso/honeysql-postgres/issues/68
Sometimes we need to use the `JOIN LATERAL` construction to optimize our queries. But such clause not so useful without `CASE WHEN THEN` expression, so I've added both ones.
Hey! It's a topic I struggle from time to time to the point where I've [asked and answered myself](https://clojureverse.org/t/passing-array-as-an-argument-to-postgresql-using-honeysql/7087) on Clojureverse recently. Mainly because it's not documented anywhere and if...
Hi, I'm running into the `subquery in FROM must have an alias` error when generating a sub query and attempting to run it in postgres. ```clojure (sql/format {:select [:type] :from...
Is there any interest in adding [Postgres JSON functions and operators](https://www.postgresql.org/docs/9.6/static/functions-json.html)? E.g. I've been using the following in my own code: ```clojure (require '[clojure.string :as str]) (require '[honeysql.format :as h-format])...
Result of the example `["INSERT INTO distributors (did, dname) VALUES (23, ?) ON CONFLICT (did) DO UPDATE SET dname = ?" "Foo Distributors" "EXCLUDED.dname || ' (formerly ' || d.dname...
I would like to achieve the following (from [here](https://www.postgresql.org/docs/9.4/static/ddl-constraints.html): ```sql CREATE TABLE example ( a integer, b integer, c integer, UNIQUE (a, c) ); ``` And I see that there...
As of now it is using `sql/call` to generate various constraints for columns, which shouldn't be the case as they are not really sql function calls. Possible better implementation would...
the new version of [honeysql](https://github.com/seancorfield/honeysql/issues/323) supports multiple values in on-conflict clause. honeysql-postgres should also support the same.
