SELECT TOP 100 *
FROM Project_12345..Demography_Current
ORDER BY NEWID()
with engine.connect() as conn:
    df = pd.read_sql("""
        SELECT TOP 100 *
        FROM Project_12345..Demography_Current
        ORDER BY NEWID()
    """, conn)

df.head()
df <- dbGetQuery(conn, "
    SELECT TOP 100 *
    FROM Project_12345..Demography_Current
    ORDER BY NEWID()
")

head(df)