Extend Dataservices with custom SQL Queries

A12 Dataservices provides a public API to access it’s database tables (for example IDocumentRepository).

If there is a need to implement a custom database query (JPA or SQL), what is the recommended way to do so?

Hello,

IDocumentRepository is not database access, it is an implementation and technology agnostic repository that can also represent nonSQL DBS or other content storages.

Data Services tables are not part of public API. It would help if you didn’t rely on DS DB structure.

If you need extra SQL queries, you should implement your custom IDocumentRepository which will be bound to your database with schema managed by you.

There is no extension point for adding custom SQL queries.