Language Integrated Query for Kotlin: You'll never want to write plain SQL again

Dear Kotlin Developers, let’s admit it: deep down, we really hate DSLs, especially SQL DSLs! When we can’t do “person.name == ‘joe’” and need to do “person.name eq ‘joe’” we’ll grin and bear it, but when it turns into “Case.When(addr.zipCode eq 14562).Then(‘J’).Else(‘Y’) instead of “if (addr.zipCode == 14562) ‘J’ else ‘Y’” we start to question whether any of these abstractions are worth their semantic weight.

Well, what I told you that I have a unique system where you CAN do all of these above things? What if I told you that you could use `==` to create normal comparisons in SQL. What if I told you could use simple `if` and `when` statements that seamlessly translate into SQL Case statements? What if I told you can use Elvis-operators in SQL queries to seamlessly handle nullable columns? What if I told you you’ll never need to deal with another Table-alias object again!?

Presenting a new system called ExoQuery that shatters all the known limits of SQL query-writing in Kotlin, on the JVM, and beyond!

https://www.youtube.com/watch?v=6DgCLeu8In8&t=6s

This will be a unique talk focusing on ExoQuery use-cases and capabilities. I will walk you through how ExoQuery can break the toughest SQL queries down into functional, composeable, and polymorphic deliciousness!

About the presenter, Alexander Ioffe:
Alexander Ioffe acquired his formative scars in the Java EE and big-data trenches, wrestling with MapReduce search indexes at eBay, object-relational impedance mismatches, and sprawling SQL in Nasdaq’s SEC-compliance systems. Those battles convinced him of the merits of functional programming, immutability, and composition.

Hungry for cleaner abstractions, Alexander plunged into the Scala ecosystem, embracing compile-time metaprogramming and LINQ-style query builders, and ultimately found his way to Kotlin. Drawing on years of meta-programming experience, he created ExoQuery, a library that brings true LINQ-grade, type-safe queries to Kotlin—with capabilities that had heretofore existed in no language or platform.

About the host and sponsor, Apex Systems:
Apex Systems is a leading global technology services firm that incorporates industry insights and experience to deliver solutions that fulfill our clients’ digital visions. We offer a continuum of services, specializing in strategy, transformation, and managed services across application development, data, enterprise platforms, cloud and infrastructure, and cybersecurity. Through our ability to innovate alongside our customers, we build and deploy the right artificial intelligence solutions to realize business value and improve customer experiences. Our alliances with cutting-edge technology partners empower our customers by providing them with the latest advancements.