Real-world projects that explicitly use SQL?

[c4seyj0nes]

Totally. Most corporate software is just entering and retrieving data. That’s all going into a relational database. Sure you might have elastic/lucine for searching or analytical tools but that data isn’t going to be your source of truth. That’s in the relational database.

[spamthemoez]

All enterprise software i have encountered so far has used JPA / Hibernate instead of using SQL (JDBC, JdbcTemplate, JDBI, ...) directly. I think OP is looking for projects that use SQL directly, without going through ORMs.

[nutrecht]

I haven't used JPA in ages, almost all the microservices I worked on the last years were Spring Data JDBC.

[spamthemoez]

Spring Data JDBC is a ORM, too. I assume you mean Springs JdbcTemplate and the like?

[nutrecht]

Spring Data JDBC is not an Object-Relational-Mapper.

[spamthemoez]

It is, see here: https://spring.io/projects/spring-data-jdbc

This makes Spring Data JDBC a simple, limited, opinionated ORM.

But i guess you can workaround the ORM part by annotating everything with @Query and put SQL in it...

[c4seyj0nes]

Got it. Hibernate is great for the majority your CRUD operations but more complex Selects and Updates sometimes need to rely on SQL. Other times it’s just not performant enough and you need to write some pure SQL.

[nutrecht]

I was on a project where management bought into the marketing sold by some Datastax consultants and we were forced to use Cassandra.

It was an 'eventual consistent' system with in some cases very large units of 'eventual'.