Question: I have been trying to find solutions for this for a few days now and can't seem to get anything to work.

The script below shows/hides columns in the tabs and works perfectly in the named sheet. I just need it to run through all of the tabs, **except for the first few**,and be applied in them too.

I just don't understand how it all works so am getting stuck.

All help hugely appreciated!!!!!!

```
function hidecolumns() {

var ss = SpreadsheetApp.getActive();
var sh = ss.getSheetByName('Jun 2025 2HR');
var first_row = sh.getRange(2,1,1,sh.getMaxColumns()).getValues().flat();
first_row.forEach((fr,i)=>{
 if(fr==0){
 sh.hideColumns(i+1);
 }
 else {
  sh.showColumns(i+1);
 }
})
}

```

Answer: 
SQLAlchemy itself only calls the cursor's `execute` method, which does not support executing multiple statements. However it's possible to access the DB API connection directly, and call its `executescript` method:

```py
import sqlalchemy as sa

engine = sa.create_engine('sqlite:///so72341960.db')

# Create a table for our example.
tbl = sa.Table(
    'mytable',
    sa.MetaData(),
    sa.Column('id', sa.Integer, primary_key=True),
    sa.Column('name', sa.String),
)

# Ensure we start with a clean table.
tbl.drop(engine, checkfirst=True)
tbl.create(engine)

SQL = """
INSERT INTO mytable (name) VALUES ('Alice');
INSERT INTO mytable (name) VALUES ('Bob');
"""

with engine.begin() as conn:
    dbapi_conn = conn.connection
    dbapi_conn.executescript(SQL)

```
This is because sqlite3 only supports executing one statement at a time. If you want to execute multiple statements, they need to be separate commands. For example,

```py
statements = [] // put your statements in this array
for statement in statements:
  session.execute(text(statement))

```

This will iterate over the array of statements and execute each one in turn.