59: Querying Trino with Java and jOOQ

Introduction

Lukas Eder from the jOOQ Object Oriented Querying project joins us to talk about Trino support for jOOQ, Java, and SQL.

Video

• Introduction and Manfred's Seattle trip (0.0s)
• Trino 445 (106.0s)
• Our guest - Lukas Eder: Java expert, Java Champion and creator of jOOQ (206.0s)
• High-level intro to jOOQ (452.0s)
• data geekery history and more jOOQ architecture (572.0s)
• Other similar systems: Java ORMs, object graph persistence, and comparison with Hibernate (711.0s)
• jOOQ for existing databases (784.0s)
• Query rewriting (899.0s)
• Other project from data geekery (1007.0s)
• jOOQ community, users, customers, and more (1145.0s)
• More comparisons: Hibernate and MyBatis (1287.0s)
• Download, distributions, features (1422.0s)
• querydsl (1565.0s)
• Support for different database: And discussion around SQL dialects (1634.0s)
• Trino details: Mmory connector, data types, type safety, and other aspects (1729.0s)
• Audience comment: Discussion about non-relational features moving to RDBMS (1987.0s)
• Audience comment: User question about jOOQ and Trino support (2120.0s)
• Trino connectors, jOOQ, testing, and issues (2235.0s)
• Different databases and function support (2442.0s)
• Demo: Including the fluent API, type safety, pojos, daos, ... (2630.0s)
• Rounding out with announcements (3678.0s)
• Trino Fest sponsors, speakers, and talks (3736.0s)

Audio

Host

• Manfred Moser, Director of Trino Community Leadership at Starburst, (@simpligility)

Guest

• Lukas Eder, Creator of jOOQ, (@lukaseder)

Trino releases

Trino 445

• Add support for time travel queries with the Delta Lake connector.
• Add support for the REPLACE modifier as part of a CREATE TABLE statement with the Delta Lake connector.
• Add support for writing Bloom filters in Parquet files with the Hive connector.
• Add support for dynamic filtering to the MongoDB connector.
• Expand support for function pushdown in the Snowflake connector.

Lukas Eder and data geekery

Lukas is recognized as a Java Champion and well-known as a very active member of the Java community. We chat about his history and involvement in the community of Java and related open source projects, and how it lead to jOOQ and his company data geekery. Lukas also briefly talks about other products.

jOOQ

jOOQ stands for jOOQ Object Oriented Querying (jOOQ). It generates Java code from your database, and lets you build type safe SQL queries through its fluent API.

All editions of jOOQ since the 3.19 release include support for Trino. The level of support depends on the used catalog and connector, and further Trino-specific enhancements are in progress.

In our conversation and demo session with Lukas, we cover all the following aspects and a few other topics:

• What is jOOQ?
• What motivated the creation of jOOQ?
• Discuss the great reasons for using jOOQ:
  • Database first
  • Typesafe SQL
  • Code generation
  • Active records
  • Multi-tenancy
  • Standardization
  • Query lifecycle
  • Procedures
• How does it compare to ORM system like Hibernate or others like the old MyBatis
• What databases are supported by jOOQ and commonly used?
• Chat about some customer use cases.
• Supported and required Java versions, fun with upgrades, and experience from customers.
• How Lukas discovered Trino and decided to add support for it.
• Challenges and interesting aspects of supporting different databases
• What is next for jOOQ in general, and Trino support specifically?
• Cool SQL features in Trino that might be suitable for standardization:
  • Higher order functions, partially already supported in jOOQ
  • Integration of object-relational database feature, such as nested collections with ARRAY or LIST.
  • Potential introduction of new concepts to SQL, such as MAP.
• Complexities from Trino having different catalogs and connectors, and the catalog, schema, table hierarchy.

jOOQ resources and further information:

• Website
• User group mailing list
• Documentation and other learning resources
• Source code
• Example projects
• jOOQ on X

Rounding out

Trino Fest news:

• Great speaker lineup announced
• More to come
• Register for event and hotel now
• Contact us to join the Trino Contributor Congregation the next day

Other news and events:

• Manfred’s recap of Open Source Summit NA and Data Engineer Things meeting in Seattle.
• Trino Contributor Call right after the episode.
• Contact us to be a guest in upcoming Trino Community Broadcast episodes.

If you want to learn more about Trino, check out the definitive guide from O’Reilly. You can get the free PDF from Starburst or buy the English, Polish, Chinese, or Japanese edition.

Music for the show is from the Megaman 6 Game Play album by Krzysztof Slowikowski.