Tangential, but this is one of the main reasons I never liked Ruby on Rails with Active Record when I first took a look at it.
Not having DB-level foreign keys by default always drove me insane. Isn't maintaining data integrity/correctness half the point of using a SQL database lol?