With API Platform you can write your own SQL / Mongo / whatever queries directly if you prefer: https://api-platform.com/docs/core/data-providers/ / https://api-platform.com/docs/core/data-persisters/
You can also customize / replace / adapt the query generated by the ORM: https://api-platform.com/docs/core/extensions/#extensions