Change a SQL function name
Recipe ID
org.openrewrite.sql.ChangeFunctionNameArtifact
org.openrewrite.recipe:rewrite-sqlWhen migrating between dialects, often one name can be substituted for another. For example, Oracle's NVL function can be replaced with Postgres COALESCE.
Usage
You’ll need the Moderne CLI configured before running the command below.
mod run . --recipe org.openrewrite.sql.ChangeFunctionName --recipe-option "oldFunctionName=NVL" --recipe-option "newFunctionName=COALESCE"If the recipe isn’t available locally, install it with:
mod config recipes jar install org.openrewrite.recipe:rewrite-sql:2.14.1Options
| Name | Type | Description |
|---|---|---|
oldFunctionNamerequired | String | The name of the function to find, case insensitive. e.g. NVL |
newFunctionNamerequired | String | The new name to use. This will match the casing of the original method when a replacement is made. e.g. COALESCE |
Data tables
Structured output this recipe can produce.
- SQL queriesShows matching SQL queries.
org.openrewrite.sql.table.DatabaseQueries - SQL functions in useShows matching SQL functions and the queries that contain them.
org.openrewrite.sql.table.DatabaseFunctions - Source files that had resultsSource files that were modified by the recipe run.
org.openrewrite.table.SourcesFileResults - Source files that had search resultsSearch results that were found during the recipe run.
org.openrewrite.table.SearchResults - Source files that errored on a recipeThe details of all errors produced by a recipe run.
org.openrewrite.table.SourcesFileErrors - Recipe performanceStatistics used in analyzing the performance of recipes.
org.openrewrite.table.RecipeRunStats