Greetings, I'd like to use the sql 'distinct' in a SQLFORM.grid 'query', but it is only valid as parameter in the 'select' method. I guess the 'group' parameter to SQLFORM.grid would work, but then I have to build the columns to group by, which seems excessive.
Is it possible to create or pass raw sql to create a 'query' object and pass as parameter to SQLFORM.grid? Many cool features of 'select' are not available in SQLFORM.grid, unless I'm missing something. Regards, Drew --
