QueryStorm 2.7.8487.32462

新的 GPT 驱动的 copilot 可让您根据 SQL 注释生成 SQL 代码。
3月 30, 2023
新版本

特性

  • QueryStorm GPT-powered Copilot - Added the new GPT-powered copilot for QueryStorm. This AI-driven feature lets you generate SQL code based on SQL comments.
    • SQL Code Generation from Comments - With the copilot, you can now generate SQL code by simply writing a descriptive comment. The AI will understand your intent and generate the code accordingly. You can invoke the copilot when you press Ctrl+Enter while the cursor is on a single-line SQL comment. The generated code is placed between two comments, allowing you to easily identify the AI-generated content. Re-running the copilot will replace any previously generated code in this block with the new one.
    • Context-Aware SQL Generation - The copilot is context-aware, which means it takes the schema of your database into consideration when generating SQL code. This allows it to create accurate and relevant code, tailored to your specific database.
    • Multilingual Prompts - You can write prompts in most human languages, even if the language of the prompt doesn't match the language of the database schema.
    • Configuring the copilot - The copilot requires that you configure it with an OpenAI API key. You can enter the API key in the General settings section.
  • Added a new "About" Sheet for Workbooks with QueryStorm Code.
    • This sheet serves to inform end users that the workbook contains QueryStorm code and provides instructions on what they need to do to run the code.
    • The "About" sheet is automatically added by the IDE whenever a workbook containing QueryStorm code is saved. If the sheet is removed, it will be recreated. You can edit it and your edits will not be overwritten, though. Note that, unedited, the sheet includes GIFs and adds approximately 1.5MB to the size of the workbook (if the GIFs are retained).
    • The automatic generation of the "About" sheet can be disabled in Settings/General settings.
  • Other changes:
    • Custom Microsoft Excel functions now support accepting 1-D arrays as parameters.
      • Note: This will not work for end users who have the older versions of the runtime.
QueryStorm 2.7.8487.32462
GPT-powered copilot

QueryStorm

Excel 插件将强大的开发和数据处理功能添加到 Microsoft Excel 中。

索取报价 立即购买

有任何疑问吗?

透过Live Chat与我们的QueryStorm 专家联络!