honeysql

Discussion of https://github.com/seancorfield/honeysql :slightly_smiling_face:
Sasha Lysenko 2020-07-31T18:56:43.313800Z

Hello! Is there a way to say "with (nolock)" using honeysql?

seancorfield 2020-07-31T18:58:41.314200Z

@alexandra.lysenko018 Is that ANSI SQL syntax or a vendor-specific extension?

Janne Sauvala 2020-08-01T17:01:13.316900Z

Are there real plans for HoneySQL 2.0 or are you just teasing us @seancorfield? πŸ™‚

seancorfield 2020-08-01T17:38:00.317100Z

@janne.sauvala Real plans. I have a OneNote section with pages of notes about it. So, it's very much in the hammock right now. But it will happen.

seancorfield 2020-08-01T17:40:16.317300Z

There's a milestone as well, with a few high-level tickets https://github.com/seancorfield/honeysql/milestones/2.0.0

Janne Sauvala 2020-08-01T18:00:22.318300Z

That’s awesome! Thanks for all of your work with honey sql and other libs πŸ™:skin-tone-2:

Sasha Lysenko 2020-07-31T19:02:37.314300Z

it's an sql server hint. example: "from some-table with (nolock)"

Sasha Lysenko 2020-07-31T19:11:46.314500Z

Oh this turned out to be easy,

(from [:mytable [:m "WITH (NOLOCK)"]])
Thanks πŸ˜…

seancorfield 2020-07-31T19:12:09.314800Z

HoneySQL doesn't support vendor-specific extensions in general. You can extend the multimethods yourself to add support for new stuff.

1πŸ‘
seancorfield 2020-07-31T19:12:32.315100Z

Ah, that probably works more by accident than by design...

seancorfield 2020-07-31T19:13:13.315300Z

I want to make this sort of thing easier/more predictable when I design HoneySQL 2.0 πŸ™‚

1πŸ˜€