Feature:

### SDK

Python

### Description

Hey lancedb team 👋

Awesome product! I was wondering, especially from the guys coming from the traditional Data Engineering, if there's plans to support an SQL data transformation tool such as dbt or sqlmesh?

Enabling this ELT type workload would be super powerful especially for metadata transformation.

The issue proposes supporting an SQL data-transformation tool such as dbt or sqlmesh for ELT and metadata transformation, but names no files, tests, or entry points. Start by clarifying the intended integration and acceptance criteria; the work is done when the supported transformation workflow and scope are defined and implemented.

Written by the indexing model from the issue text.