rexshijaku / sql-to-laravel-builder Goto Github PK

INSERT INTO 'table' ('id', 'field') VALUES (22, -5);

Besides array(), for PHP >= 5.4 it should support also the short syntax [ ].

"union" "union all" gives the same result >union(DB::...
I think must be unionAll(DB::..

I just found this package and found it very interesting. I have tested it with a query, it worked quite well, however it had an error.

SQL Query:

UPDATE ps_feature_value_lang a 
JOIN ps_feature_value_lang b ON a.id_feature_value = b.id_feature_value and CHAR_LENGTH(b.value) > 0
SET a.value = b.value
WHERE a.value = ''

Result:

DB::table('ps_feature_value_lang a')
->where('a.value','=','')
->join('ps_feature_value_lang b','a.id_feature_value','=and>','b.id_feature_value')
->update(['a.value'=>DB::raw('b.value')]);

The problem is in '=and>'
CHAR_LENGTH(b.value) > 0 is also ignored.

I want to get a Builder object but without get
I want to keep working on it.

possible?

edit: Now I notice that it just generates a string without activation…

Awesome tool
Found a small bug

If you alias the table it gets parsed twice

select * from users as u
join roles as r on r.id = u.role_id
where u.id = 1

DB::table('users as u as u')...

doesn't support for "using" clause on join query

SELECT * FROM A JOIN B using (b_id)

Example:
Input: select count(*) from table_name where is_active = 0
Output: DB::table('table_name')->count()->where('is_active','=',0);

Output is invalid eloquent, as it first execute count and on that count where clause cannot be executed and gives
Erorr: "Call to a member function whereIn() on int"