When I finally unraveled the nested views, which had several unnecessary joins and columns, and wrote a plain query, the time for that same query dropped to subseconds. 3. Do use table-valued ...

Editing query nested in another edit. Searches nested fields by wrapping another query. nested field objects are searched as if they were separate documents when a nested query is used.

Even if generative AI hides SQL behind the curtain, it will continue to play a critical role in how we interact with and use data.