QueryStorm 2.7.8487.32462

El nuevo copiloto impulsado por GPT le permite generar código SQL basado en comentarios SQL.
Marzo 30, 2023
Nueva versión

Características

  • 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

El complemento de Excel agrega potentes funcionalidades de desarrollo y procesamiento de datos en Microsoft Excel.

Solicitar presupuesto Comprar ahora

¿Alguna pregunta?

Chatee en vivo ahora mismo con nuestros especialistas en licencias de QueryStorm.