Skip to main content

Change a SQL function name

org.openrewrite.sql.ChangeFunctionName

When migrating between dialects, often one name can be substituted for another. For example, Oracle's NVL function can be replaced with Postgres COALESCE.

Recipe source​

This recipe is only available to users of Moderne.

This recipe is available under the Moderne Proprietary License.

Options​

TypeNameDescriptionExample
StringoldFunctionNameThe name of the function to find, case insensitive.NVL
StringnewFunctionNameThe new name to use. This will match the casing of the original method when a replacement is made.COALESCE

Usage​

This recipe has required configuration parameters and can only be run by users of Moderne. To run this recipe, you will need to provide the Moderne CLI run command with the required options. Or, if you'd like to create a declarative recipe, please see the below example of a rewrite.yml file:

rewrite.yml
---
type: specs.openrewrite.org/v1beta/recipe
name: com.yourorg.ChangeFunctionNameExample
displayName: Change a SQL function name example
recipeList:
  - org.openrewrite.sql.ChangeFunctionName: 
      oldFunctionName: NVL
      newFunctionName: COALESCE

You will need to have configured the Moderne CLI on your machine before you can run the following command.

shell
mod run . --recipe ChangeFunctionName --recipe-option "oldFunctionName=NVL" --recipe-option "newFunctionName=COALESCE"

If the recipe is not available locally, then you can install it using:

mod config recipes jar install org.openrewrite.recipe:rewrite-sql:2.3.0

See how this recipe works across multiple open-source repositories​

Run this recipe on OSS repos at scale with the Moderne SaaS.

The community edition of the Moderne platform enables you to easily run recipes across thousands of open-source repositories.

Please contact Moderne for more information about safely running the recipes on your own codebase in a private SaaS.

Data Tables​

SQL queries​

org.openrewrite.sql.table.DatabaseQueries

Shows matching SQL queries.

Column NameDescription
Source pathThe path to the source file.
QueryThe text of the query.

Contributors​

Jonathan Schneider, Tim te Beek