3 ms·
I don’t see the point of using an SQL like language instead of actual SQL unless you need to support multiple different RDBMSs.
by fixedsys 7y ago
I don’t see the point of using an SQL like language instead of actual SQL unless you need to support multiple different RDBMSs.
- steve_taylor 7y agoOne of the nicer JPQL features is being able to navigate the Java object model and have that translated to the equivalent joins in SQL. However, there are things that JPQL can’t do, but it’s easy enough to create a native SQL query and have its results map to JPA entities. I use Spring Boot (JPA, Spring Data, Spring Data REST) for the sheer convenience of it and speed of development, not to abstract away the database, which is always PostgreSQL. I am very comfortable writing SQL queries and making use of PostgreSQL-specific features and Spring Boot with JPA certainly lets me do that when I want to.