Does Concourse support the Structured Query Language (SQL)?

No.

Concourse uses a functional API for most create-read-update-delete (CRUD) database interactions. For queries, you can use the Concourse Criteria Language (CCL).