Is SQL plenty good enough for complex data transformation?

From: Robert <irishhacker_at_gmail.com>
Date: Thu, 15 Nov 2007 12:58:59 -0800 (PST)
Message-ID: <d15a4785-c1a9-4d51-b1c8-2f174a1c1b54@a28g2000hsc.googlegroups.com>

When doing complex data transformation ( data preparation, data manipulation, etc. ) , perhaps when preparing data for statistical analysis, or perhaps in an ETL context, is the SQL programming language plenty good enough?

For that type of work, can you be just as productive using SQL syntax, and not using at all the SAS or SPSS programming languages?

I think that the pitch of the ELT folks ( ELT vs ETL) is : with the SQL programming language, there is no use for any other data manipulation programming language. Received on Thu Nov 15 2007 - 14:58:59 CST