top of page

zAI Query

zAI Query allows anyone who wishes to analyze the data stored in the zAI repository to either directly write SQL queries or to use AI to generate those queries directly for them.  Once the SQL is generated, it can be copied and pasted directly into a tool like DB Browser for sqlite3 and executed.

​

​​​

File queries - show all DSNs that substitute symbolic parameters

​​​​​

Programmer request to AI…….

 

using the DSN table in database DSN, show all entries where there is a "&" character in the dsn_name_original but there is not a "&" character in dsn_name_final. Sort the list in dsn_name_final order ascending

bottom of page