Back to Prompts

Write a SQL Query from Requirements

Ask Copilot to translate a human requirement into a SQL SELECT query.

category:database

0

Prompt

Write a SQL query for this requirement:
  
  [Describe the tables, relationships, and what you want to retrieve]
  
  Requirements:
  - Use explicit JOINs instead of implicit joins.
  - Alias tables to keep the query readable.
  - Order and limit results if appropriate.
  
  After the query, add a brief explanation.

Related Prompts

Full SQL to ORM Migration (Prisma/TypeORM)

Transform raw SQL queries across a codebase into ORM equivalents.

category:modernizationsqlorm+4

Migrate SQL Schema to Prisma Schema

Convert CREATE TABLE SQL into a Prisma schema.prisma file.

category:modernizationprismasql+2

Migrate SQL Query to ORM (Prisma/TypeORM)

Convert raw SQL queries to type-safe ORM operations.

modernizationmigrationsql+3

Investigate a Slow Database Query

Use Copilot to analyze and optimize slow SQL/Prisma queries.

category:databaseperformancesql+2

Add a New Prisma Entity

Use Copilot to define a new Prisma model, migrate, seed, and test it.

category:databaseprismaschema+2

Generate Database Migration Scripts

Have Copilot generate migration scripts for schema changes based on a before/after view.

category:databasemigrationsschema

Browse More Prompts