Affordability in SF

My partner is considering job opportunities in the Bay Area and trying to understand if it’s realistic to move from Boston. We have an infant and would likely be around a $400k household income. Is it actually possible to buy a home in the suburbs(<1 hour commute from downtown) or does the cost of housing and childcare make it feel too stretched? Would really appreciate honest perspectives from families currently living there.