I believe what the OP is asking for is the ability to insert a new record from within the Retool table interface.
The legacy Table component had a "Show add row button" option that provided a similar interface, but this is still missing from the new Table component.
I agree that it feels very cumbersome currently to add a new row to the DB once you already have a table setup with all the needed columns in the right format, especially when some of these are editable.
+1