Logical and physical optimizations for SQL query execution over large language models