[Feature] How to support dimension lookup query for transform

### Search before asking

- [X] I had searched in the [feature](https://github.com/apache/seatunnel/issues?q=is%3Aissue+label%3A%22Feature%22) and found no similar feature requirement.

### Description

How to support dimension lookup query for transform

And as EtLT data synchronization, I think we need to support lookup query for transform, and I want to hear from you all how you think it can be implemented in SeaTunnel.

### Usage Scenario

_No response_

### Related issues

_No response_

### Are you willing to submit a PR?

- [ ] Yes I am willing to submit a PR!

### Code of Conduct

- [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)