Can you explain what is meant by a neat and logically simple SQL query?

A neat and logically minimal SQL query is a query that:

• Performs only the necessary task, without redundant conditions or calculations.
• Is easy to read and maintain.
• Uses parameters to prevent SQL injection.
• Does not contain business logic that should be implemented in application code.

For example, instead of writing a complex query with many conditions and calculations, it is better to make a simple query that returns data, and leave the processing logic in PHP code:

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

Such a query is simple, clear, and does not contain unnecessary logic.