> ## Documentation Index
> Fetch the complete documentation index at: https://docs.prophecy.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# Visual expression builder

> About the visual expression builder

Use the visual expression builder to write complex SQL expressions without worrying about syntax. The visual expression builder can help you to better understand the relationships between different functions and their arguments. You can use visual expressions in gems and data tests.

<Info>
  To understand how to build expressions with the visual expression build, see the [reference
  guide](/data-analysis/gems/visual-expression-builder/visual-expression-builder-reference).
</Info>

## Build with Copilot

You can use Copilot from the visual expression builder for additional help. Whether you're exploring functions, learning what's possible, or writing expressions with prompts, Copilot supports your workflow.

<img src="https://mintcdn.com/prophecy-62973bd0/TCE9ttntwn-TDkv6/data-analysis/gems/visual-expression-builder/img/copilot-visual-expression.png?fit=max&auto=format&n=TCE9ttntwn-TDkv6&q=85&s=1bf307c9820fd4a68fcfc302c5cf873b" alt="Copilot in the visual expression builder" width="2870" height="1610" data-path="data-analysis/gems/visual-expression-builder/img/copilot-visual-expression.png" />

## Code view

To view the SQL expressions generated by the visual expression builder, you can switch to the Code view of a gem or of the project. If you update any expressions in the Code view, they will be converted back to visual expressions in the Visual view.

<img src="https://mintcdn.com/prophecy-62973bd0/TCE9ttntwn-TDkv6/data-analysis/gems/visual-expression-builder/img/code-expression-builder.png?fit=max&auto=format&n=TCE9ttntwn-TDkv6&q=85&s=a52fa3ac958b24b2c9c841521fc18c0c" alt="Code Expression Builder" width="2620" height="1509" data-path="data-analysis/gems/visual-expression-builder/img/code-expression-builder.png" />

You can also ask Copilot to generate SQL expressions directly in the Code view.

<Note>
  The SQL dialect for expressions depends on the SQL warehouse connection of the fabric. This is
  because the project code must be compatible with the execution environment it runs on. Because of
  this, expressions may look different across projects that run on Databricks versus Snowflake, for
  example.
</Note>

## What's next

To continue developing with the visual expression builder, see the following pages: