From Query Tools to Causal Architects: Harnessing Large Language Models for Advanced Causal Discovery from Data