[Bug]: Missing fields in body of request can lead to SQL syntax error

[aaronburtle]

What happened?

When a field is missing from the body for a request that maps to insert operations this should either result in a working request where DAB is able to determine the field in question and assign insert something like a default value, or it should result in error messaging that is clear to the user. Currently we are instead running into a SQL Syntax exception.

Version

1.3

What database are you using?

Azure SQL

What hosting model are you using?

No response

Which API approach are you accessing DAB through?

No response

Relevant log output

Code of Conduct

• I agree to follow this project's Code of Conduct