← All recipes
Moderne licensed

Ensure parameterized SQL queries

Recipe IDorg.openrewrite.scala.recipes.migrate.database.SecureSqlQueries
Artifactio.moderne.recipe:recipes-scala

Finds raw SQL string patterns such as sql"...", SQL(...), or s"SELECT...". Ensure parameterized queries are used to prevent SQL injection.

Single recipeProprietary

Usage

This recipe has no required configuration options. You’ll need the Moderne CLI configured before running the command below.

mod run . --recipe org.openrewrite.scala.recipes.migrate.database.SecureSqlQueries

If the recipe isn’t available locally, install it with:

mod config recipes jar install io.moderne.recipe:recipes-scala:0.3.1

Data tables

Structured output this recipe can produce.

  • 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