The assistant lives in the database too
Most AI features bolted onto business software keep a stale copy of your schema and a guardrail written in English. If the application already lives in the database, the assistant can live there too — fenced by SQL Server itself.