Renaming and finding usages
The IDE correctly resolves all table and column references over your SQL files and allows you to rename any symbol and its usages easily.
When you rename the symbol inside SQL, it is also renamed in all usages inside
Sometimes you just need to find usages inside console/sql files, DataGrip does it.
It can be a variable or parameter of the function.
It can be an alias of a table or column. The same works for a name of a CTE.
It can be a database object you have just created in the console.
If it is an existing object like table or column, it will be renamed in the datasource as well.