Google's Spanner doesn't support foreign keys but does support interleaved tables to cover some use cases of foreign keys. Spanner sees wide use inside Google.
The usual routes for data consistency between tables are batch clean up or in-app validation.