Thanks Chris for the elaborate response. For now we had to go with second approach. In fact, first approach is reasonable, I have recommended and asked them for that equivalent view to SQL query.
But, max() doesn't work with dates. Any direct function…