Can i perform join inside silvertransform.json dlt meta issue

[DivyanshuSati007]

I have to covert below query to json so that it can be run easily

insert into silver_customers values a,b,c,d
select "bc.a", bc.b,bc.c, concat(dd.year+dd.periodnumber) as d
from bronze_customer bc left join dimDate dd on bc.date == dd.date

is this possible
Here source table is bronze_customer
target table is silver_customers
and 3rd table on which join is performed dimDate

how can i achieve this in silvertransform.json

[ravi-databricks]

@DivyanshuSati007 only sql expressions are supported, sql queries with join not supported as of now! There is a feature request here which might cover above scenario in coming release v0.0.10