Point-in-time & look-ahead bias

How the fundamentals data preserves every observation with its filing date, what as_of does, and how to build a survivorship- and look-ahead-free backtest.