rom-rb.org icon indicating copy to clipboard operation
rom-rb.org copied to clipboard

Add example of using a CTE

Open ianks opened this issue 6 years ago • 2 comments

This PR adds an example of using a CTE. I think examples like this are good to have because it illustrates how powerful ROM can be in advanced scenarios.

This example might be more fitting under some Advanced section, but currently, there is not one. Do you think tit would be worthwhile to do that or should I save that for a later PR?

ianks avatar Aug 21 '19 11:08 ianks

This is very helpful, a couple of remarks though:

  • Reaching out to Sequel directly is possible but discouraged, because if something is not possible in rom-sql then it's a missing feature, and we gotta add it; however, it shouldn't of course block anybody from doing advanced stuff. It would be good to somehow explain this
  • It feels like this kind of stuff should be moved to "Advanced" section of SQL docs

WDYT?

solnic avatar Aug 30 '19 06:08 solnic

Agree with advanced section and explanation that it is an escape hatch. I'll update.

ianks avatar Sep 03 '19 04:09 ianks