{"author_name":"m1104m","categories":["SQL"],"blog_url":"https://tameshitemita.blog/","provider_name":"Hatena Blog","type":"rich","title":"sqlfmt\u304b\u3089sqlfluff\u306b\u4e57\u308a\u63db\u3048\u305f","provider_url":"https://hatena.blog","author_url":"https://blog.hatena.ne.jp/m1104m/","description":"www.sqlfluff.com \u80cc\u666f \u4ed5\u4e8b\u3067\u306edbt\u306ejinja\u306eformatter\u306bsqlfmt\u3092\u4f7f\u3063\u3066\u3044\u305f syntax error\u7b49\u304c\u691c\u77e5\u3055\u308c\u306a\u3044\u4e8b\u304c\u8ab2\u984c\u3060\u3063\u305f \u540c\u50da\u304c\u63d0\u6848PR\u3057\u3066\u304f\u308c\u305f\u306e\u3067\u4f7f\u3063\u3066\u307f\u308b \u5165\u308c\u3066\u307f\u305f pip install sqlfluff echo \" SELECT a + b FROM tbl; \" > test.sql sqlfluff lint test.sql --dialect ansi \u4f7f\u3063\u3066\u7121\u3044CTE\u3092\u691c\u51fa\u3057\u3066\u304f\u308c\u305f\u308a\u3082\u3059\u308b \u601d\u3063\u305f\u3088\u308a\u3082\u9ad8\u6a5f\u80fd\u3067\u826f\u3055\u305d\u3046","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Ftameshitemita.blog%2Fentry%2F2026%2F02%2F04%2F232951\" title=\"sqlfmt\u304b\u3089sqlfluff\u306b\u4e57\u308a\u63db\u3048\u305f - \u8a66\u3057\u3066\u307f\u305f\u30d6\u30ed\u30b0\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","height":"190","blog_title":"\u8a66\u3057\u3066\u307f\u305f\u30d6\u30ed\u30b0","image_url":null,"url":"https://tameshitemita.blog/entry/2026/02/04/232951","version":"1.0","width":"100%","published":"2026-02-04 23:29:51"}