Use of Load in Script Editor

[ashwath26_95]

Load statement precedes SQL statements whenever i load data from a db.

1. What is the use of load statement?

2. When would load statement be useful and not useful?

3. If my db table has 6 columns, my load statement also has 6 columns. But if i create a new field under "Load" statement then will i face error since Load statement has 7 fields and SQL statement has 6 fields? 

4. If i write add a new column under SQL Statement should i also add a field under "Load" statement with same output?

[lironbaram]

hi 

1. load statement allows you , to add calculated fields on top of the existing fields from SQL query or any table 
    with out the need referance the table, or call the table , it makes your script more readable . 

2.it's not about useful , there are some cases you can't use it , as if you join two table the load will only consider the first table , ordering the table is also something you can't use in preceding load .

3.no problem to add columns, as long as they are built using the fields in the Sql query 

4. yes you'll need to update both parts