My question is, 'how much of this work could have been shoved into an SQL database which would give you the type checking and referential integrity needed' , w

My question is, 'how much of this work could have been shoved into an SQL database which would give you the type checking and referential integrity needed' , with then a relatively thin layer of non-SQL programming on top to handle the ETL tasks mentioned?