[Feature]: SQLTarget Record before Schema should fail nicely

[visch]

Feature scope

Targets (data type handling, batching, SQL object generation, etc.)

Description

Should go on SQL Target milestone

https://github.com/MeltanoLabs/target-postgres/blob/main/target_postgres/tests/test_standard_target.py#L64 is the record_before_schema test

We should fail nicely, this test was taken from https://github.com/MeltanoLabs/target-sqlite/blob/master/tests/test_target_sqlite.py#L23-L32

We should probably do the validation in the SDK

[visch]

Here's an example implementation MeltanoLabs/target-postgres#57