>>Do you have some freedom with the table? Or maybe the ability to create a new one specifically to support this query?


Yes, I have total control of the table what did you have in mind?