In PHPStorm IDE there is files .phpstorm.meta.php that help the IDE to figure out some project contexts for example moodle table prefix when there is in the code {table_name} it's automaticaly interpter it's as mdl_table_name and if you connect your database to the IDE it will verifiy your queries and autocompletes it if needed.

may be we can add this file as development file or at least put it in git ignore for the PHPStorm developer users to not commit it by mistake

.phpstorm.meta.php

<?php

namespace PHPSTORM_META {

    override(

    // Virtual function to indicate that all SQL

    // injections will have the following replacement rules.

    sql_injection_subst(),

    map([

        '{' => "mdl_", // all `{` in injected SQL strings will be replaced with a prefix 

        '}' => '', // all `}` will be replaced with an empty string

    ]));

}