mtimofiiv / express-query-params

Express.js middleware implementing the API Query Spec, converting the query to something queryable to an SQL or Mongo database.

Hai! 👋

I'm a freelance Javascript developer.

I build...

• web-based apps using whatever makes sense
• mobile apps using React Native
• desktop apps using Electron

I might be available to help you with your project – feel free to message me on Twitter (@mtimofiiv) or email me at contact [at] fiiv.io.

express-query-params's Issues

Create an interface for "through" association types

Make it possible to query for things related through another object.

cc @chrissvo

Implement multiple values in this query...

The API query spec can be enhanced to have multiple values:

/users?name=joe,john

This can be converted to IN ('joe','john') in SQL query.

We should also be able to have the following to have a partial match for multiple values:
/users?name=joe,john

Implement a possible negation for a query

See mgmco/api-query-spec#1

Add support for SQL output

Currently, this middleware only supports Mongo syntax, but...

Would be nice if it allowed people to generate a portion of an SQL query to append to an existing one. So for instance...

/users?username=*steve*&age%3E18 would produce:

username LIKE `%steve%` AND age > 18

This would be appendable to a WHERE clause in any query like so:

var query = 'SELECT * FROM users WHERE ' + req.parsedQuery;