Question 1

Does TextQL support Azure AD authentication for Azure SQL?

Accepted Answer

Yes. TextQL supports Azure AD authentication natively, including service principals, managed identities, and interactive user tokens. This means TextQL integrates with your existing Azure identity management — no separate credentials to manage. Azure AD conditional access policies and MFA requirements are fully respected.

Question 2

Can TextQL query Azure SQL Managed Instance?

Accepted Answer

Yes. TextQL supports both Azure SQL Database and Azure SQL Managed Instance. For Managed Instance, provide the instance endpoint and credentials. All features — schema discovery, relationship mapping, and T-SQL query generation — work identically across both deployment options.

Question 3

Does TextQL work with Azure SQL elastic pools?

Accepted Answer

Yes. TextQL can connect to any database within an elastic pool. It discovers schemas and tables for each connected database independently. You can connect multiple databases from the same elastic pool and ask questions that join data across them.

Question 4

How does TextQL handle T-SQL specific syntax?

Accepted Answer

Ana generates native T-SQL queries, including SQL Server-specific functions, date handling, and syntax. It understands T-SQL idioms like TOP, CROSS APPLY, and common table expressions, producing queries that are both correct and performant on Azure SQL.

Question 5

Can I combine Azure SQL data with other cloud databases?

Accepted Answer

Yes. TextQL excels at multi-source queries. You can ask a single question that joins Azure SQL transactional data with Snowflake analytics, BigQuery event data, or any other connected source. TextQL handles the cross-database orchestration and returns a unified result.