Insert data to another table/module

Good day. I have a module called Inquiries. After I create a new record in this module, I want to add a new record at the same time using some of those fields from the previous module to a different module. Is there any way I can achieve this? Like using a raw sql? Thank you in advance.

You can do that from the UI with a Workflow (On save, New records, no repeated runs).

It is also possible from PHP code, using logic hook (after_save), where you can use the full power of the data objects (called beans).