How can we caputre the UserID on registration using Live Forms, to then use that UserID in an SQL script on Form Submission?
You can use Execute SQL action after the Registration action(Manage > Options > Actions > On Form Submission > Add Action > SQL > Excute SQL).
And use [User:userid] token in the Execute SQL action.