Is it possible to form SQL queries working with objects and their relations instead of directly accessing tables?

Yes, in Java, it is possible to form SQL queries by working with objects and their relationships, instead of directly accessing tables. This is implemented using ORM (Object-Relational Mapping) frameworks such as Hibernate or JPA.

The main idea is that you work with classes and objects, and ORM automatically translates operations with them into SQL queries to the database.

For example, instead of writing an SQL query to select users, you can write:

TypedQuery<User> query = entityManager.createQuery("SELECT u FROM User u WHERE u.age > :age", User.class);
query.setParameter("age", 18);
List<User> users = query.getResultList();

Here, User is an entity class linked to a table in the database, and entityManager manages the interaction with the database.

Thus, ORM allows working with objects and their relationships, rather than directly with tables and SQL, which simplifies development and improves code readability.