<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom" xmlns:dc="http://purl.org/dc/elements/1.1/">
  <channel>
    <title>DEV Community: JJ Labajo</title>
    <description>The latest articles on DEV Community by JJ Labajo (@jjlabajo).</description>
    <link>https://dev.to/jjlabajo</link>
    <image>
      <url>https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F189263%2Fe5851d2b-f0c4-4b71-85e0-09690a7a6f14.jpg</url>
      <title>DEV Community: JJ Labajo</title>
      <link>https://dev.to/jjlabajo</link>
    </image>
    <atom:link rel="self" type="application/rss+xml" href="https://dev.to/feed/jjlabajo"/>
    <language>en</language>
    <item>
      <title>SQL to Eloquent Laravel Converter Tool</title>
      <dc:creator>JJ Labajo</dc:creator>
      <pubDate>Sun, 18 Apr 2021 12:35:15 +0000</pubDate>
      <link>https://dev.to/jjlabajo/sql-to-eloquent-laravel-converter-tool-1eci</link>
      <guid>https://dev.to/jjlabajo/sql-to-eloquent-laravel-converter-tool-1eci</guid>
      <description>&lt;p&gt;So last week I've been looking for a tool that can convert my raw SQL Statements into a Laravel Eloquent Query Builder but to no avail. So I decided to make one myself.&lt;/p&gt;

&lt;p&gt;SQLtoEloquent is an app that lets you convert SQL Statements into Laravel Eloquent Query Builders.&lt;/p&gt;

&lt;p&gt;Feel free to use it here:&lt;br&gt;
&lt;a href="https://jjlabajo.github.io/SQLtoEloquent/" rel="noopener noreferrer"&gt;https://jjlabajo.github.io/SQLtoEloquent/&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;I've set a couple of rules for accuracy.&lt;/p&gt;

&lt;p&gt;Rules:  &lt;/p&gt;

&lt;ol&gt;
&lt;li&gt;Use parentheses when using BETWEEN operator.
e.g.    SELECT * FROM t WHERE (column_name BETWEEN value1 AND value2); &lt;/li&gt;
&lt;li&gt;When using ALIAS, always use the AS linking verb.
e.g.    SELECT uid AS &lt;code&gt;user_id&lt;/code&gt;; &lt;/li&gt;
&lt;li&gt;Always use backticks (`) for aliases.&lt;/li&gt;
&lt;/ol&gt;

</description>
    </item>
  </channel>
</rss>
