Workaround: Max aggregate function doesn't work with reserved keyword

ServiceStack Auto Query
1

Hi,
we are using auto query and we discovery a limitation that could be useful to document to avoid loose of time.

Use Case
As a user I’d like to get the Max value of a property called Order.

Repro
call the auto query function by using ?Include=Max(Order)

Sql produced by OrmLite

SELECT Max(Order) "Max(Order)", COUNT(*) "COUNT(*)" 
FROM "ShowTrip"."RoutingRules"

Result
System.Data.SqlClient.SqlException: ‘Incorrect syntax near the keyword ‘Order’.’

Workaround
Call the auto query function by using ?Include=Max(Order) LastOrder

Sql produced by OrmLite

SELECT MAX("ShowTrip"."RoutingRules"."Order") LastOrder, COUNT(*) "COUNT(*)" 
FROM "ShowTrip"."RoutingRules"

Result
Work as expected.

HTH