specql
specql copied to clipboard
tatut
Automatic PostgreSQL CRUD queries
I like specql for forcing namespaces on all clojure side keywords, but I can't get it to recognize schemas when defining tables.
Support having a nested query as a value in an operator. Currently the user needs to make two queries: first running the subquery and passing the results in the `in`...
For example, trying to insert data with unknown column will cause AssertionError, which will not be caught if user is trying to catch all Exceptions. It is better to throw...
For example, the following SQL is not possible: ```SQL SELECT * FROM sometable WHERE (start,end) OVERLAPS (?,?) ``` We could allow a multi column key, by specifying it as a...
Composite parsing fails for range types, for example: `"No method in multimethod 'parse-value' for dispatch value: int4range"`
A misconfigured rel (has-one or has-many) can cause an NPE in fetch. - Better validation of relations in define-tables phase - Better error message about trying to query a missing...
``` SELECT * FROM company c LEFT JOIN employee e ON e.company = c.id WHERE e.deleted IS NOT TRUE ``` Does not return any rows, if all the employees are...
In this case we have generic translation table that is used for string translations. ``` +--------------+ +-------------------+ | | 1 * | | | translation +---------+ translation_value | | |...
It is possible to have many-to-many links, but the link table must be its own defined table. Add support to directly add a many-to-many mapping without the need to specify...
Adds option for doing SELECT DISTINCT and SELECT DISTINCT ON in fetch, see #45 for more details. Here's the initial implementation idea. I'm a little bit hesitant because of the...
