Is it possible to use SuiteQL for Lot numbered item fulfillments from a sales order? would that be some method of transform?

SuiteQL is read-only

I probably should of checked that before starting the project, hah.