DraganSr: DataGrip with parametrized SQL queries

Thursday, February 01, 2024

Open settings by pressing Ctrl+Alt+S and navigate to Database | Query Execution | User Parameters.

Substitute inside SQL strings

Apply parameter patterns to string literals in the SQL code.

For example, consider the following code.

SELECT ${column_name}
FROM actor
WHERE actor_id='${actor_id}'

even this works

SELECT * FROM table WHERE column = :value

Just run it via Ctrl+Enter! (command+return on Mac keyboard)