encapsulated SQL/JPQL code in DAO for API, added informations such as labels, filters...