Can you use SQL functions with the Splunk ODBC driver?

[OCAO]

Can you use any of the different SQL functions (say, the aggregate functions: avg, sum, etc.) together the Splunk ODBC driver? What about WHERE or GROUP BY clauses? Or can you only perform simple SELECT?

Since you can only manipulate saved searches through the Splunk ODBC driver, I'm afraid the answer to my questions is "no, you cannot" but...

Thank you.

[OCAO]

So, I did some tests.

A query such as "SELECT ALL A.OPERATION, sum( A.count ) FROM La_proportion_des_operations A GROUP BY A.OPERATION" works with the old 1.0.1 ODBC driver but gives no result with the recent 2.0 driver ! Looks then like a bug in the recent version of the driver...

[tlagatta_splunk]

What's your use case? Maybe DB Connect does the trick?

https://splunkbase.splunk.com/apps/#/page/1/search/db%2520connect/order/relevance