Datatables won't render for Query CSVs for non "Select *" queries

[jqnatividad]

CKAN Version if known (or site URL)

This is for https://github.com/ckan/ckan/tree/3816-query-based-views

Please describe the expected behaviour

For Stored Queries using explicitly declared result columns (not "select *" - see #4148 ), a data publisher can add a Datatables resource view without issue.

Please describe the actual behaviour

You get an error - "DataTables warning: table id=dtprv - Ajax error. For more information about this error, please see http://datatables.net/tn/7"

It appears datatables is expecting an "_ID" column. Perhaps, let datatables generate it?

What steps can be taken to reproduce the issue?

Create a Stored Query not using "select *", e.g.

select "MAIL_ZIPCODE", count(*),  sum( cast( "GROSS_TAX" as int)) as "SUMGROSS" from "e37aeb54-c17f-4a70-a502-fc7cce474812" group by "MAIL_ZIPCODE" order by "SUMGROSS" desc, "MAIL_ZIPCODE" asc limit 15

and then try to create a Datatables Resource View

[jqnatividad]

A workaround for this with Query CSVs is to use the row_number() window function to create a computed column when defining the select statement:

select row_number() over() as "_id",...