Copy data and subdata

I’m using direct query to Firebase.

I would like to have a button that will copy an existing record (and all sub records) to a new record with sub records.

I have a table called Offer, and this table is linked to Product.
I would like to copy an offer and his product, so that I can link it to another customer.

I believe you can achieve this only by using Automations or workflows