Does corteza-server support select max(table.field) syntax return the current max field value?
No, but you can sort by that column (descending) and limit the result to one – basically the same output.
The reporter, however, does support some more of those querying features.