SQL is evolving within the streaming space, emphasizing the need to view tables as dynamic entities that change over time. This approach allows for the efficient computation of results based on real-time data changes, rather than relying on static tables. The discussion highlights the importance of deriving dynamic tables from event streams and the flexibility users have in connecting these dynamic elements to the outside world.