sql-to-builder

sql-to-builder copied to clipboard

Update .travis.yml

2

Big-Shark

**SQL** = `select * from t1 join t2 on (t1.column1 = t2.column1) where t1.column2 = t2.column2` **EXPECTED** = `DB::table('t1')->join('t2', 't1.column1', '=','t2.column1' )->whereRaw('t1.column2 = t2.column2')` **RESULT** = `DB::table('t1')->where('t2.column2', '=', '')->get()` >...

xStarman

Online tool.

3

Хорошо бы сделать онлайн версию.

LordJohn42

Is that a yes?

mkantautas

Input: ``` sql DELETE items FROM items left join items as parent on items.parentID = parent.itemID WHERE parent.itemID is NULL ``` Output: ``` php DB::table('items') ->leftJoin('items', 'items.parentid', '=', 'parent.itemid') ->whereNull('parent.itemid')...

SerafimArts