feat: update support subquery

[zhyass]

mysql> create table t1(id1 int, val1 varchar(255));
Query OK, 0 rows affected (0.01 sec)

mysql> create table t2(id2 int, val2 varchar(255));
Query OK, 0 rows affected (0.01 sec)

mysql> insert into t1 values (1,'1') ;
Query OK, 1 row affected (0.01 sec)

mysql> insert into t2 values (1,'2');
Query OK, 1 row affected (0.01 sec)

mysql> update t1 set val1 = (select val2 from t2 where id1 = id2) where id1 in (select id2 from t2);
ERROR 1105 (HY000): Code: 1001, displayText = Unsupported physical scalar: SubqueryExpr(SubqueryExpr { typ: Any, subquery: SExpr { plan: EvalScalar(EvalScalar { items: [ScalarItem { scalar: BoundColumnRef(BoundColumnRef { column: ColumnBinding { database_name: Some("default"), table_name: Some("t2"), column_name: "id2", index: 4, data_type: Int32(Int32), visibility: Visible } }), index: 4 }] }), children: [SExpr { plan: LogicalGet(LogicalGet { table_index: 2, columns: {5, 4}, push_down_predicates: None, limit: None, order_by: