TCSR‐SQL: Towards Table Content‐Aware Text‐to‐SQL With Self‐Retrieval (CAAI Transactions on Intelligence Technology, 2026)