We released a new version for avoiding DB block by long running selects via API for mysql >= 5.7.4 and mariaDB >= 10.1.1

[macropay-solutions]

Besides the BaseModel's attribute

protected bool $indexRequiredOnFiltering = true;

we added a new feature that works alongside:

public bool $transformInSubSelectsInTemporaryTables = true;

From now, this will also limit the max execution time for selects via API to:
(int)(\env('API_SELECT_TIMEOUT') ?? \env('HTTP_TIMEOUT', 50))
for mysql >= 5.7.4 and mariadb >= 10.1.1. PostgreSQL needs transaction for this to be set at statement level and we did not code it.