That is working as intended. `close()` just resets the session and
connection, returning it to a connection pool to be used again.
https://docs.sqlalchemy.org/en/20/orm/session_basics.html#closing
The Session.close()
from sqlalchemy import create_engine,text
from sqlalchemy.orm import sessionmaker, declarative_base
from datetime import datetime
from sqlalchemy.orm import relationship
from sqlalchemy import Column, ForeignKey, Integer, String, DateTime, Text,
Boolean
from sqlalchemy.orm import scoped_session