AI suggestions.

I'm not part of your AI program waiting list. However here what I suggest.

Do not make the AI part of your program an only cloud-based solution. There are plenty of opensource code models free for commercial use that can be ran locally on a PC. These models can also run under CPU but will up the memory to enable this feature requirements for AI on client side only. It's too dangerous for Redgate to store this information on the cloud even with a solid EULA, and laws are subject to change. Please offload this burden back to the users.

Things I should ask it to do and have it do it.

Have it build a local vector db / learn the database based on SQL History.

Do query rewriting.
Example: Tell it don't use case( and use convert( or vise versa and it will rewrite the syntax.

Describe a SQL function/SP and have it write that code.

Have it analyzed Query execution plan and make suggestions to the SQL query to improve its performance, like suggesting indexes, or a rewrite of the query to improve performance.

Document my query / or document my database.

Explain a data problem and have it try to figure it out. Example:
Q: On Order 123, why is that order being reported Cancelled.

A: You have QueryOrders you have a case statement ISCancelled if the Cancelled date is not null it returned as Cancelled.
 
Q; What job will execute this stored procedure?
A: Job RunSalesOrder step 4 will call this stored procedure.

Translate SQL lang to another SQL lang.