https://www.kingsware.de/2011/06/15/convert-programmatically-created-queries-to-named-queries/