Question 1

How do I integrate RQL with GORM for pagination and filtering?

Accepted Answer

Define your Go struct with rql tags, create a parser using rql.NewParser with the model, then use the generated Params (FilterExp, FilterArgs, Limit, Offset, Sort) in GORM's Where, Limit, Offset, and Order methods. The README provides a full example in the Getting Started section.

Question 2

RQL vs GraphQL for building APIs in Go?

Accepted Answer

RQL is better for REST APIs where you want to maintain simple HTTP queries with MongoDB-like syntax and direct SQL integration, while GraphQL suits complex client-defined queries with schema stitching. RQL focuses on translating JSON to SQL for Go ORMs without the overhead of a GraphQL server.

Question 3

Can RQL handle queries with multiple OR conditions and nesting?

Accepted Answer

Yes, RQL supports the $or operator for disjunctions at any level, allowing logical OR conditions. However, it currently lacks $not and $nor, and nested queries require flattened database fields, with true join support planned for the future.

Question 4

What databases does RQL actually support?

Accepted Answer

RQL works with any SQL database through compatible Go ORMs like GORM, Ent, XORM, and go-pg, as it translates to standard SQL clauses. It does not natively support NoSQL databases like MongoDB, though that's a future goal.

Question 5

How to set up custom time formats in RQL filters?

Accepted Answer

Use the layout option in rql struct tags, e.g., `rql:"filter,layout=2006-01-02"` for custom time parsing. By default, it uses RFC3339, but you can override it with standard or custom layouts as shown in the API documentation.

Question 6

Is RQL safe from SQL injection attacks?

Accepted Answer

Yes, RQL prevents SQL injection by using parameterized queries with placeholders for all user inputs in the generated SQL. The validation step ensures type safety, and the FilterArgs contain safe values to bind to the database.

rql

What is rql?

Overview

Use Cases

Best For

Related Projects

Found a gem we're missing?

Not Ideal For

Pros & Cons

Pros

Cons

Frequently Asked Questions