I don't see why not. Presumably you would connect to the database and prepare the statement when the Lambda function starts up and execute the prepared statemen

I don't see why not. Presumably you would connect to the database and prepare the statement when the Lambda function starts up and execute the prepared statement from the per-request handler invoked.