Doctrine Query Language Support
When working with Doctrine ORM, the preferred, and probably the easiest, way to work with database queries is to use the Doctrine Query Language or DQL. DQL is a query language for your object model: instead of composing raw SQL with the names of tables and columns, you refer to the names of your PHP classes and fields to fetch or update data.
You can learn more about DQL in the documentation, and, if you haven’t yet, start using it in PhpStorm 2018.3!
To begin working with a DQL string, perform a DQL language injection first:
- For a simple string, add the
/** @lang DQL */annotation before the injected code piece.
- For Nowdoc/Heredoc strings, set the marker to
DQL, and the DQL language will be automatically injected. If necessary, you can customize this marker in Settings / Preferences | Editor | Language Injections.
Then, compose the string! PhpStorm will highlight it properly, but DQL support doesn’t end there.
PhpStorm resolves the references to the classes and fields that you refer to, which lets you navigate directly to them using the Go to declaration command (Ctrl/Cmd + Click the desired symbol or press Ctrl/Cmd + B). You can also perform rename refactoring of classes and fields either from their declaration or from a usage:
This works for associations as well:
In the future releases, we plan to introduce automatic language injection and code completion for DQL. Stay tuned and let us know what other features you’d like to see!
Your JetBrains PhpStorm Team
The Drive to Develop
Subscribe to Blog updates
Thanks, we've got you!
Qodana Clone Finder: Early Access Program
In December 2020, we announced the EAP for Qodana, which is rapidly evolving into a comprehensive platform that allows companies to perform multi-level evaluations of the quality of code they own, contract, or purchase. Qodana helps you detect bugs without relying on an IDE, either on a local machi…
PhpStorm 2020.2 EAP #3
The Early Access Program for PhpStorm 2020.2 is in full swing and today we’ve got the third build of the 2020.2 EAP for you. In this blog post, you can read about improvements for Git installed in WSL2 and Search Everywhere. Download PhpStorm 2020.2 EAP (more…)…
PhpStorm 2019.3.3 Preview
We’ve just rolled out a preview for the third minor update for PhpStorm 2019.3. Please give the PhpStorm 2019.3.3 Preview build 193.6494.5 a try and share your feedback with us. (more…)…
How to Upgrade to PHP 7.4 with PhpStorm
Check out our fresh video with a few nice tips and tricks on how to update your codebase to PHP 7.4. It combines materials from the PhpStorm 2019.2 and PhpStorm 2019.3 releases, with a few cool bonuses to boot. Nikita drew our attention to the fact that setters are slower than assigning prop…