Text-To-Sql Systems In The Era Of Advanced Large Language Models