Common Table Expressions in ActiveRecord ft. Vlado Cingel - RUBY 523

<!-- wp:paragraph --> <p>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.</p> <!-- /wp:paragraph --> <!-- wp:paragraph --> <p>Vlado explains what Common Table Expressions (CTEs) are, how they work, and where they're used.</p> <!-- /wp:paragraph --> <!-- wp:heading --> <h2>Panel</h2> <!-- /wp:heading --> <!-- wp:list --> <ul><li>John Epperson</li><li>Luke Stutters</li><li>Valentino Stoll</li></ul> <!-- /wp:list --> <!-- wp:heading --> <h2>Guest</h2> <!-- /wp:heading --> <!-- wp:list --> <ul><li><meta charset="utf-8">Vlado Cingel</li></ul> <!-- /wp:list --> <!-- wp:heading --> <h2>Sponsors</h2> <!-- /wp:heading --> <!-- wp:list --> <ul><li><a href="https://topenddevs.com/" target="_blank" rel="noreferrer noopener">Top End Devs</a></li><li><a href="https://raygun.com/platform/apm?utm_medium=podcast&amp;utm_source=rubyrogues&amp;utm_campaign=devchat&amp;utm_content=apm" target="_blank" rel="noreferrer noopener">Raygun | Click here to get started on your free 14-day trial</a></li><li><a href="https://topenddevs.com/" target="_blank" rel="noreferrer noopener">Coaching | Top End Devs</a></li></ul> <!-- /wp:list --> <!-- wp:heading --> <h2>Links</h2> <!-- /wp:heading --> <!-- wp:list --> <ul><li><a href="https://github.com/vlado/activerecord-cte" target="_blank" rel="noreferrer noopener">GitHub | vlado/activerecord-cte</a></li><li><a href="https://vlado.github.io/slides/2019-12-12-organising-complex-sql-queries-in-rails/#/" target="_blank" rel="noreferrer noopener">Organising complex SQL queries in Rails</a></li><li><a href="https://github.com/vlado" target="_blank" rel="noreferrer noopener">GitHub: Vlado Cingel ( vlado )</a></li></ul> <!-- /wp:list --> <!-- wp:heading --> <h2>Picks</h2> <!-- /wp:heading --> <!-- wp:list --> <ul><li>John-<a href="https://www.digitalstorm.com/" target="_blank" rel="noreferrer noopener