@worldsendless Damn. Sounds like they indeed could try to mitigate to the outlying programming language, or use stored procedures.

@worldsendless Or move to another technology entirely like a data lake or data warehouse solution and transform the data on the way in, it's unlikely a 45 minute query is part of a transactional system i'd think?