Vlado Cingel recounts his story where he needed common table expressions within SQL for a project he was working on and wrote a patch to AREL and ActiveRecord which he submitted to the Rails Core. Since it hasn't been accepted, he's supporting it as a gem.

Vlado explains what Common Table Expressions (CTEs) are, how they work, and where they're used.

Panel * John Epperson * Luke Stutters * Valentino Stoll

Guest * Vlado Cingel

Sponsors * Top End Devs * Raygun | Click here to get started on your free 14-day trial * Coaching | Top End Devs

Links * GitHub | vlado/activerecord-cte * Organising complex SQL queries in Rails * GitHub: Vlado Cingel ( vlado )

Picks * John- Digital Storm: Custom Gaming Computers & Gaming PCs * Luke- Pitch Perfect * Valentino- Ruby Together * Valentino- Ruby Central * Valentino- The Ruby VM a speedrun - Penelope Phippen * Vlado- The Wood Whisperer Guild - Online Woodworking School * Vlado- Polished Ruby Programming

Contact John:

• Rock Agile Consulting
• GitHub: John Epperson ( kirillian )
• LinkedIn: John Epperson

Contact Luke:

• GitHub: Luke Stutters ( lukestuts )

Contact Valentino:

• Doximity Technology Blog
• Work @ Doximity
• GitHub: Valentino Stoll ( codenamev )
• Twitter: V ( @thecodenamev )

Special Guest: Vlado Cingel.