SQL statements that beyond DML, are not possible. Currently, they are not possible in Dbt. Having more features in SQL statements will support us. Another issue is the terms of data ingestion because Dbt requires sources to be defined, and you need to handle data ingestion with other tools. So having a data injection tool integrated within dbt will be awesome.
What is data integration? Data integration is the process of combining data that resides in multiple sources into one unified set. This is done for analytical uses as well as for operational uses.
SQL statements that beyond DML, are not possible. Currently, they are not possible in Dbt. Having more features in SQL statements will support us. Another issue is the terms of data ingestion because Dbt requires sources to be defined, and you need to handle data ingestion with other tools. So having a data injection tool integrated within dbt will be awesome.