1with engine.connect() as conn:2    df = pd.read_sql("""3        SELECT TOP 1004               s.PROCHI,5               d.sex,6               d.Calculated_Age,7               s.ADMISSION_DATE,8               s.DISCHARGE_DATE,9               s.LENGTH_OF_STAY,10               s.MAIN_CONDITION,11               s.MAIN_OPERATION12        FROM Project_12345..SMR01_Admissions s13        INNER JOIN Project_12345..Demography_Current d14            ON s.PROCHI = d.PROCHI15        ORDER BY NEWID()16    """, conn)17 18df.head()

1df <- dbGetQuery(conn, "2    SELECT TOP 1003           s.PROCHI,4           d.sex,5           d.Calculated_Age,6           s.ADMISSION_DATE,7           s.DISCHARGE_DATE,8           s.LENGTH_OF_STAY,9           s.MAIN_CONDITION,10           s.MAIN_OPERATION11    FROM Project_12345..SMR01_Admissions s12    INNER JOIN Project_12345..Demography_Current d13        ON s.PROCHI = d.PROCHI14    ORDER BY NEWID()15")16 17head(df)