Question 1

How to use SxQL with PostgreSQL?

Accepted Answer

Set *quote-character* to #" and use PostgreSQL-specific clauses like ON CONFLICT in your queries. However, you'll need a separate library for actual database connections, as SxQL only handles SQL generation.

Question 2

SxQL vs CLSQL: which should I use?

Accepted Answer

SxQL focuses on safe, programmatic SQL generation without ORM features, while CLSQL is a full ORM with database abstraction. Choose SxQL for fine-grained SQL control or CLSQL for higher-level object mapping.

Question 3

Can SxQL handle complex subqueries?

Accepted Answer

Yes, SxQL supports subqueries in FROM and WHERE clauses, as demonstrated in examples where SELECT statements are nested, allowing for advanced query composition.

Question 4

How to install SxQL in Quicklisp?

Accepted Answer

Evaluate (ql:quickload :sxql) in your Common Lisp environment. Ensure your project's .asd file includes it as a dependency for seamless integration.

Question 5

Does SxQL support database migrations?

Accepted Answer

No, SxQL provides SQL generation for CREATE TABLE and ALTER TABLE but doesn't include migration tools. You'd need to build custom scripts or use other libraries for versioned schema changes.

Question 6

How to prevent SQL injection with SxQL?

Accepted Answer

Always use SxQL's operators (e.g., :=, :>) instead of raw strings; the library automatically parameterizes values, as seen in the yield output with placeholders, ensuring safe query construction.

composable query builder

Overview

Use Cases

Not Ideal For

Pros & Cons

Pros

Related Projects

Found a gem we're missing?

Cons

Frequently Asked Questions