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.PanelJohn EppersonLuke StuttersValentino StollGuestVlado CingelSponsorsTop End DevsRaygun | Click here to get started on your free 14-day trialCoaching | Top End DevsLinksGitHub | vlado/activerecord-cteOrganising complex SQL queries in RailsGitHub: Vlado Cingel ( vlado )PicksJohn- Digital Storm: Custom Gaming Computers & Gaming PCsLuke- Pitch PerfectValentino- Ruby TogetherValentino- Ruby CentralValentino- The Ruby VM a speedrun - Penelope PhippenVlado- The Wood Whisperer Guild - Online Woodworking SchoolVlado- Polished Ruby ProgrammingContact John:Rock Agile ConsultingGitHub: John Epperson ( kirillian )LinkedIn: John EppersonContact Luke:GitHub: Luke Stutters ( lukestuts )Contact Valentino:Doximity Technology BlogWork @ DoximityGitHub: Valentino Stoll ( codenamev )Twitter: V ( @thecodenamev )Special Guest: Vlado Cingel.Sponsored By:Coaching | Top End Devs: Do you want to level up your career? or go freelance? or start a podcast or youtube channel? Let Charles Max Wood Help You Achieve Your DreamsTop End Devs: Learn to Become a Top 5% Developer. Join our community of ambitious and engaged programmers to learn how.Raygun : Raygun now offers a modern approach to error and performance monitoring. Start your 14-day free trial now.Advertising Inquiries: https://redcircle.com/brandsPrivacy & Opt-Out: https://redcircle.com/privacyBecome a supporter of this podcast: https://www.spreaker.com/podcast/ruby-rogues--6102073/support.