honeysql

seancorfield 2023-08-27T17:40:55.019359Z

This message contains interactive elements.

seancorfield 2023-08-27T00:07:14.457059Z

If anyone feels inclined to test "what's coming next", I'd appreciate feedback on the current develop branch either via git deps or the 2.4.9999-SNAPSHOT on Clojars. Here's what in so far: • 2.4.next in progress • Add :select with function call and alias example to README (PR https://github.com/seancorfield/honeysql/pull/502 @markbastian). • Address https://github.com/seancorfield/honeysql/issues/501 by making INSERT INTO (and REPLACE INTO) use the :columns or :values clauses to produce column names (which are then omitted from those other clauses). • Address https://github.com/seancorfield/honeysql/issues/497 by adding :alias special syntax. • Address https://github.com/seancorfield/honeysql/issues/496 by adding :overriding-value option to :insert clause. Documentation TBD. • Address https://github.com/seancorfield/honeysql/issues/407 by adding support for temporal queries (see FROM in https://cljdoc.org/d/com.github.seancorfield/honeysql/CURRENT/doc/getting-started/sql-clause-reference#from). • Address https://github.com/seancorfield/honeysql/issues/389 by adding examples of [:only :table] producing ONLY(table). • Add :create-or-replace-view to support PostgreSQL's lack of IF NOT EXISTS for CREATE VIEW. • Attempt to clarify the formatting behavior of the :values clause when used to produce column names. • Update tools.build to 0.9.5 (and remove :java-opts setting from build/run-task)

dharrigan 2023-08-27T19:58:06.342179Z

awesome-sauce! 🙂

seancorfield 2023-08-27T21:02:34.578039Z

@dharrigan The temporal query stuff is because I'm hoping to use HoneySQL to produce XTDB 2 SQL at some point 🙂

dharrigan 2023-08-27T21:07:32.803899Z

Very interesting stuff - I'll have to read up on it more! 🙂