Analyzing the Effectiveness of Large Language Models on Text-to-SQL Synthesis