How to Implement Natural Join in Python without using Pandas

Question

• Should be done using single function

• Shouldn't use Pandas or merge function or any other inbuilt database libraries

Answer 1

You can use native driver like psycopg2 for postgres https://www.psycopg.org/docs/usage.html

import psycopg2

# Connect to an existing database
conn = psycopg2.connect("dbname=test user=postgres")
cur = conn.cursor()



# Query the database and obtain data as Python objects
cur.execute("""
SELECT * FROM test t
left join test1 t1 on (t.t1_id = t1.id);
""")
fetched_rows = cur.fetchall()


# Make the changes to the database persistent
conn.commit()

# Close communication with the database
cur.close()
conn.close()