As you can see, constructing a simple SELECT statement in Java is almost as simple as constructing a simple SELECT statement in SQL. The more features you want to use, the more complicated it gets.

Microsoft has open sourced the Java language extension it added to SQL Server 2019 last year.

Here's a quick JDBC with HSQLDB tutorial to get you up and running with Java database connectivity and the popular HyperSQL database.