>>> What about other engines like Oracle or MS SQL?
>>
>> MSSQL have command-line BCP (buck copy) utility and BULK INSERT
>> statement and allow to ignore any constraints and disable insert triggers.
>> More - this is default behavior :
>> [...]
>
> What happens when bulk insert brings database into inconsistent state?
> What means does admin have to repair the database (restore consistency)?

Of course - admin\dbo\someone else must check constraints after such
process if its needed.

>> Permissions
>> Only members of the sysadmin and bulkadmin fixed server roles can execute BULK INSERT.
>
> Hmmm... personally I would go with GRANT BULK INSERT ON <...> TO <...> .

This is the same as including user into bulkadmin server role (in MSSQL of course)

Regards,
Vlad