sql-to-builder
sql-to-builder copied to clipboard
Column comparation in where clause
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()
PHP Notice: Undefined index: value in E:\dev\laravel_test\sql-to-builder-master\src\Converter\WhereConverter.php on line 52
*This is a simplified version of a large query that I tried to convert