Excel函数生成SQL插入语句

insert into

= "INSERT INTO new_sa_original(" & ARRAYTOTEXT(B1:T1,0) & ") VALUES"

value：

="("&TEXTJOIN(",",FALSE,LAMBDA(x,IF(x="NULL",x,"'"&x&"'"))(B2:T2))&"),"

(可自动判断NULL值来决定是否添加引号)