Generative AI's New Frontier: Predictive Modeling with Tabular Foundation Models