There were a few issues caused by adobe themselves (i.e. a few releases of the client were signed by expired certs which were getting blocked, frankly for good reason).  They were...

Useful or not, if no one gets investigated and fined as a result - it will quickly turn into something useless.  unless you' show that you are in fact willing...

Since you're not at liberty to share the queries - the only input I would have is - eat the elephant one bite a t a time.  The one query...

A CTE with ROW_NUMBER() would do it.

With testCTE as (
 Select row_number() over (partition by factkey order by StartRateDate DESC) RN, * 
from factview
where StartRateDate=<CustomerDateTicket)
Select * from...

I think AI driven dev is one of those marketing hype jingles going along with the often unrealistic promise of AI.  "just tell it what you want and it will...

Not sure AI plays a huge role in here, since a human is still describing the requirements.  This feels a bit more like a lot of the standards being worked...