{"id":336,"date":"2011-05-15T17:51:57","date_gmt":"2011-05-15T15:51:57","guid":{"rendered":"http:\/\/www.speich.net\/articles\/?p=336"},"modified":"2017-09-08T16:29:43","modified_gmt":"2017-09-08T14:29:43","slug":"why-i-love-jetbrains-phpstorm-ii","status":"publish","type":"post","link":"https:\/\/www.speich.net\/articles\/en\/2011\/05\/15\/why-i-love-jetbrains-phpstorm-ii\/","title":{"rendered":"Why I love PhpStorm: SQL table aliases"},"content":{"rendered":"<p>Here&#8217;s another example for the reason why I like <a href=\"https:\/\/www.jetbrains.com\/phpstorm\/\" target=\"_blank\" rel=\"noopener\">JetBrains PhpStorm<\/a> so much: SQL code assist in the Database Console completes statements either in upper case or lower case depending on how you started typing, not to speak of understanding aliased tables when suggesting column names after typing a dot.<\/p>\n<figure style=\"width: 686px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\" \" title=\"Screenshot of SQL code assist in PhpStorm\" src=\"\/articles\/images\/screenshot-PhpStorm02.gif\" alt=\"\" width=\"686\" height=\"199\" \/><figcaption class=\"wp-caption-text\">Screenshot: SQL code assist in PhpStorm understands aliased tables.<\/figcaption><\/figure>\n<p>More PhpStorm love:<br \/>\n<a href=\"https:\/\/www.speich.net\/articles\/en\/2017\/09\/08\/why-i-love-jetbrains-phpstorm-sql-group-by-handling\/\">SQL GROUP BY handling<\/a><br \/>\n<a href=\"https:\/\/www.speich.net\/articles\/en\/2010\/07\/16\/javascript-and-dojo-with-phpstorm\/\">JavaScript code completion with dojo<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Here&#8217;s another example for the reason why I like JetBrains PhpStorm so much: SQL code assist in the Database Console completes statements either in upper case or lower case depending on how you started typing, not to speak of understanding aliased tables when suggesting column names after typing a dot. More PhpStorm love: SQL GROUP &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/www.speich.net\/articles\/en\/2011\/05\/15\/why-i-love-jetbrains-phpstorm-ii\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;Why I love PhpStorm: SQL table aliases&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,6],"tags":[75],"class_list":["post-336","post","type-post","status-publish","format-standard","hentry","category-javascript","category-php","tag-phpstorm","entry"],"_links":{"self":[{"href":"https:\/\/www.speich.net\/articles\/wp-json\/wp\/v2\/posts\/336","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.speich.net\/articles\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.speich.net\/articles\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.speich.net\/articles\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.speich.net\/articles\/wp-json\/wp\/v2\/comments?post=336"}],"version-history":[{"count":6,"href":"https:\/\/www.speich.net\/articles\/wp-json\/wp\/v2\/posts\/336\/revisions"}],"predecessor-version":[{"id":1406,"href":"https:\/\/www.speich.net\/articles\/wp-json\/wp\/v2\/posts\/336\/revisions\/1406"}],"wp:attachment":[{"href":"https:\/\/www.speich.net\/articles\/wp-json\/wp\/v2\/media?parent=336"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.speich.net\/articles\/wp-json\/wp\/v2\/categories?post=336"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.speich.net\/articles\/wp-json\/wp\/v2\/tags?post=336"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}