sql icon indicating copy to clipboard operation
sql copied to clipboard

`with` is documented but not provided

Open greghendershott opened this issue 4 years ago • 2 comments

I tried to use with (for a CTE) but got an undefined error.

Glancing at the commit history I see:

  • commit a58ca7b added with
  • commit fdba335 removed with but left it in the documentation
  • commit d6823de updated the documentation about an enhancement

I may be overlooking something. I'm not sure the intent -- does the reality needs to change to match the docs, or vice versa.

greghendershott avatar Apr 26 '21 00:04 greghendershott

with is still allowed in a statement, but it's no longer a Racket macro like select. It means you have to write (sql (with ....)) instead of just (with ....).

rmculpepper avatar Apr 26 '21 16:04 rmculpepper

Oh!

  1. That's awesome it's available, I just tried and it worked great!

  2. Should I make a PR to add that to the doc for with --- as a margin-note or inline prose? Or should it be some change to the grammar? (Or do you think it's already apparent and I'm just being dense -- which is 100% just to tell me bluntly. :smile:)

greghendershott avatar Apr 26 '21 16:04 greghendershott