Junior — Middle

Have you used pure SQL queries without ORM or other abstractions in your work?

sobes.tech AI

Answer from AI

Yes, using raw SQL queries without ORM or other abstractions is common, especially when maximum control over queries, performance optimization, or working with non-standard database constructs is required. For example, in Python, you can use the psycopg2 library to work directly with PostgreSQL:

import psycopg2

conn = psycopg2.connect(dbname="testdb", user="user", password="pass", host="localhost")
cursor = conn.cursor()
cursor.execute("SELECT id, name FROM users WHERE active = TRUE")
rows = cursor.fetchall()
for row in rows:
    print(row)
cursor.close()
conn.close()

This approach allows writing precise queries, using database-specific functions, and better controlling transactions.

Previous Next