Do you write queries that adhere to principles of cleanliness and readability when working with databases?

Yes, when working with a database, it is important to write queries that are easy to read and maintain. This includes:

• Using clear and unambiguous names for tables and fields.
• Formatting SQL queries with indentation and line breaks to improve readability.
• Avoiding redundant or complex nested queries when the logic can be simplified.
• Using parameterized queries for security and clarity.

An example of a readable PHP query with PDO:

$sql = "SELECT id, name, email FROM users WHERE status = :status ORDER BY created_at DESC";
$stmt = $pdo->prepare($sql);
$stmt->execute(['status' => 'active']);
$users = $stmt->fetchAll();

This approach makes maintenance easier and reduces the likelihood of errors.