You are architecting a Node.js mobile news feed application with data storage on Google Cloud. The database selection must support: zonal resiliency by default, low-latency responses, ACID compliance, an optional middle tier, semi-structured data storage capabilities, and client libraries that tolerate network partitions and offline mode. Which database solution should you choose?