Sql

Hello guys I was reading through this tutorial https://docs.llamaindex.ai/en/stable/examples/index_structs/struct_indices/duckdb_sql_query/?h=sql


Now can anyone please check if my understanding is correct, in the first section of the tutorial, NLSQLTableQueryEngine is used which essentially ONLY generates SQL from natural language and then runs it inside the database.

Whereas, SQLTableRetrieverQueryEngine is using Text2SQL but also additional embedding based retrieval for gathering additional information before passing the final context to the text2sql and then we get the final sql?