I'm working with a driver that makes very extensive SQL statements, so my code ends up being disgusted with 2000 lines of pure String to go to executeQuery() , is there a good practice ( I do not want to make use of non-maintainable methods or that break the MVC model) to store these SQL queries in variables in some external file that can be used by the controller? Do I have to continue storing them in local variables to the controller? Could services be useful, or is it not a valid option?
Thank you very much already.