{"provider_name":"Hatena Blog","blog_url":"https://toft.hatenadiary.org/","url":"https://toft.hatenadiary.org/entry/20081006/1223272024","width":"100%","version":"1.0","image_url":null,"blog_title":"\u30b9\u30ea\u30fc\u30c0\u30a6\u30f3\u30d6\u30ed\u30b0","title":" SQL \u3092 DBIC \u3067\u3046\u307e\u304f\u4f7f\u3046","categories":["per"],"author_url":"https://blog.hatena.ne.jp/toft/","height":"190","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Ftoft.hatenadiary.org%2Fentry%2F20081006%2F1223272024\" title=\" SQL \u3092 DBIC \u3067\u3046\u307e\u304f\u4f7f\u3046 - \u30b9\u30ea\u30fc\u30c0\u30a6\u30f3\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>","published":"2008-10-06 14:47:04","type":"rich","author_name":"toft","provider_url":"https://hatena.blog","description":"DBIC Custom ResultSource for Arbitrary SQLSo you haven't figured out how to write a complex query in DBIC yet? No worries, DBIC will allow you to write that query in SQL. To do so one: Defines a custom ResultSource based on an existing one. Pass the new ResultSource's name method the raw SQL. Regist\u2026"}