Yes, Zoho Analytics supports full-fledged SQL based querying of your database. It understands SQL SELECT Queries written in any of the well-known database dialects including Oracle, Microsoft SQL Server, IBM DB2, Sybase, MySQL, PostgreSQL, Informix and ANSI SQL.
You can use SQLs from any of the below methods:
- From the Zoho Analytics User Interface, create Query Tables to execute SQL SELECT queries in Zoho Analytics. You can then generate reports over the Query Table created. Check out this Video on Creating Query Tables
- Use Zoho CloudSQL API to execute SQL SELECT queries on Zoho Analytics. You could use Zoho CloudSQL API when you want to integrate Zoho Analytics within your own applications.