CSNW/sql-bricks issues and pull requests

#137 - Support for REGEXP_LIKE query

Pull Request - State: closed - Opened by chikku1780 over 1 year ago - 1 comment

#136 - Fix bug in _.clone() reimplementation, closes #135

Pull Request - State: closed - Opened by prust over 1 year ago

#135 - Error while using sql-bricks clone() function

Issue - State: closed - Opened by vileoleone over 1 year ago - 2 comments

#134 - Bump flat and mocha

Pull Request - State: open - Opened by dependabot[bot] about 2 years ago
Labels: dependencies

#133 - Project Ownership / Maintenance

Issue - State: open - Opened by prust over 2 years ago - 11 comments

#132 - Add "RETURNING" for inserts and updates

Issue - State: closed - Opened by WillTwait over 2 years ago - 2 comments

#131 - Converting Object column with arrary to in clause

Issue - State: open - Opened by doshisunny over 2 years ago

#130 - Incorrect value index when using where(sql(...))

Issue - State: open - Opened by w33ble over 2 years ago

#129 - Module '"sql-bricks"' has no exported member 'distinct'.

Issue - State: closed - Opened by Goldy98 over 3 years ago

#128 - vulnerable issue with underscore

Issue - State: closed - Opened by kayvaninvemo over 3 years ago - 1 comment

#127 - remove underscore from sql-bricks codebase

Pull Request - State: closed - Opened by pgarrison over 3 years ago - 1 comment

#126 - Npm Audit - Arbitrary Code Execution - underscore

Issue - State: closed - Opened by talha-aftab over 3 years ago - 1 comment

#125 - Type definition problem

Issue - State: open - Opened by kayvaninvemo about 4 years ago - 1 comment

#124 - Add overrideable identifier preparation methods

Pull Request - State: open - Opened by ClaireNeveu over 4 years ago - 2 comments

#123 - Infinit recursion in subclass function.

Issue - State: closed - Opened by recursive-beast over 4 years ago - 1 comment

#122 - TypeScript definitions are missing from the published package

Issue - State: closed - Opened by AndKiel over 4 years ago - 2 comments

#121 - can you add this feature

Issue - State: open - Opened by julientype over 4 years ago

#120 - How do I perform matematical operations in an update

Issue - State: closed - Opened by joviwap over 4 years ago - 2 comments

#119 - Fix clone of embedded literal sql

Pull Request - State: closed - Opened by prust over 4 years ago

#118 - Using clone() on a query throws an error.

Issue - State: closed - Opened by michaldrabik over 4 years ago - 1 comment
Labels: bug

#117 - how can i use `delete` with 'join'

Issue - State: open - Opened by BugKun almost 5 years ago
Labels: question

#116 - sql-bricks reserved words should come from spec & should be easy to override

Issue - State: open - Opened by prust almost 5 years ago
Labels: enhancement

#115 - can not use 'using' after delete

Issue - State: closed - Opened by BugKun almost 5 years ago - 1 comment

#114 - why can't I use "user" as the name of table

Issue - State: closed - Opened by BugKun almost 5 years ago - 1 comment

#113 - CTE support (Common Table Expressions) WITH query

Issue - State: closed - Opened by karianpour over 5 years ago - 1 comment

#112 - remove underscore from sql-bricks codebase

Pull Request - State: closed - Opened by schuttsm over 5 years ago

#111 - update package.json so it uses mocha without npm audit issues

Pull Request - State: closed - Opened by schuttsm over 5 years ago - 1 comment

#110 - TRUNCATE feature?

Issue - State: closed - Opened by privateOmega almost 6 years ago - 2 comments

#109 - Add TypeScript definitions

Pull Request - State: closed - Opened by paleo about 6 years ago - 1 comment

#108 - fix(v2): output `.noWait()` as 'NOWAIT'

Pull Request - State: closed - Opened by joelmukuthu over 6 years ago - 5 comments

#107 - fix(v2): output `.noWait()` as 'NOWAIT'

Pull Request - State: closed - Opened by joelmukuthu over 6 years ago - 1 comment

#106 - fix: output `.noWait()` as 'NOWAIT'

Pull Request - State: closed - Opened by joelmukuthu over 6 years ago

#105 - `noWait` generates incorrect SQL

Issue - State: closed - Opened by joelmukuthu over 6 years ago - 4 comments

#104 - auto-quoting doesn't work with default mysql settings

Issue - State: open - Opened by prust over 6 years ago

#103 - `sql().toParams()` generating wrong parameter bindings

Issue - State: closed - Opened by joelmukuthu almost 7 years ago - 5 comments

#102 - Feature request: support unicode characters.

Issue - State: closed - Opened by parro-it almost 7 years ago - 2 comments

#101 - Autoquoting non-overridable

Issue - State: open - Opened by Suor almost 7 years ago - 5 comments

#100 - Replace custom templating with ES2015 template literals

Pull Request - State: closed - Opened by prust almost 7 years ago - 3 comments

#99 - inheritance (private methods as sql._ use as is for overriding)

Pull Request - State: closed - Opened by cybermerlin about 7 years ago - 1 comment

#98 - parametrised queries with array values

Issue - State: open - Opened by cybermerlin about 7 years ago

#97 - allow cloning of statements using in with a subquery

Pull Request - State: closed - Opened by chrisbajorin over 7 years ago - 2 comments

#96 - `sql()` overeagerly converts dollar characters into parameter placeholders

Issue - State: closed - Opened by sneakertack over 7 years ago - 5 comments

#95 - Typescript Definition

Issue - State: closed - Opened by jbrassard almost 8 years ago - 4 comments

#94 - fix #82 - Incorrect Value Order For Multiple Inserts

Pull Request - State: closed - Opened by tailsu almost 8 years ago - 2 comments

#93 - Allow setting defaults from the outside and empty placeholders

Pull Request - State: closed - Opened by kay999 over 8 years ago - 3 comments

#92 - Major Refactors

Issue - State: open - Opened by prust over 8 years ago - 6 comments
Labels: enhancement

#91 - Conflict with pg-promise

Issue - State: open - Opened by kay999 over 8 years ago - 4 comments

#90 - Add an advice to docs to use .toParams() over .toString()

Issue - State: closed - Opened by Suor over 8 years ago - 5 comments

#89 - Hi! Can you merge these 3 fixes?

Pull Request - State: closed - Opened by vitalif over 8 years ago - 4 comments

#88 - Support raw sql blocks in expressions, allow to convert expression to string

Pull Request - State: closed - Opened by vitalif over 8 years ago - 2 comments

#87 - Need for 'INSERT INTO TableName DEFAULT VALUES '

Issue - State: open - Opened by coderuid over 8 years ago - 1 comment
Labels: good first issue

#86 - Expose both "reserved" and the auto quoting character

Pull Request - State: closed - Opened by olivierkaisin over 8 years ago - 3 comments

#85 - Better sql() params support

Pull Request - State: closed - Opened by prust almost 9 years ago - 6 comments

#84 - Parametric sql() doesn't work with .toString()

Issue - State: closed - Opened by Suor almost 9 years ago - 1 comment
Labels: bug

#83 - Upsert queries

Issue - State: closed - Opened by danturu almost 9 years ago - 2 comments

#82 - Incorrect Value Order For Multiple Inserts

Issue - State: closed - Opened by bendytree almost 9 years ago - 2 comments
Labels: bug

#81 - Remove buggy array support

Issue - State: closed - Opened by prust about 9 years ago - 2 comments

#80 - Fix doubled params

Pull Request - State: closed - Opened by prust about 9 years ago

#79 - Wrong number of params with sub query?

Issue - State: closed - Opened by barbogast about 9 years ago - 2 comments

#78 - array update/inserts malformed

Issue - State: closed - Opened by nbrustein over 9 years ago - 8 comments

#77 - sql() params don't work in fields or tables list

Issue - State: open - Opened by Suor over 9 years ago - 3 comments

#76 - Better sql() params support

Issue - State: closed - Opened by Suor over 9 years ago - 3 comments

#75 - Document sql() placeholders

Issue - State: closed - Opened by Suor over 9 years ago - 2 comments

#74 - Params support to sql()

Issue - State: closed - Opened by Suor over 9 years ago - 2 comments

#73 - Finish ORDER BY support: ASC, DESC & collations

Issue - State: open - Opened by prust over 9 years ago - 1 comment
Labels: good first issue

#72 - Composite "WHERE IN" Support

Issue - State: closed - Opened by nickschwab over 9 years ago - 2 comments

#71 - Exposed SQL Expression classes for easier re-use/extension via sql-bricks-postgres

Pull Request - State: closed - Opened by prust over 9 years ago

#70 - Add a way to add new operators

Issue - State: closed - Opened by mauritslamers over 9 years ago - 1 comment

#69 - how to use overlap(&&) operator?

Issue - State: closed - Opened by SanderElias over 9 years ago - 1 comment

#68 - Rhino support

Issue - State: closed - Opened by prust over 9 years ago - 1 comment

#67 - Support for NATURAL JOIN (on top of JOIN USING)

Pull Request - State: closed - Opened by sneakertack almost 10 years ago - 2 comments

#66 - .crossJoin() requires onCriteria, even though it shoudn't

Issue - State: closed - Opened by sneakertack almost 10 years ago - 2 comments

#65 - Support for JOIN USING

Pull Request - State: closed - Opened by sneakertack almost 10 years ago - 1 comment

#64 - Support for JOIN USING?

Issue - State: closed - Opened by sneakertack almost 10 years ago - 4 comments

#63 - Limit and offset

Issue - State: closed - Opened by devchakraborty almost 10 years ago - 1 comment

#62 - Need a way to add new converters

Issue - State: open - Opened by Suor almost 10 years ago - 5 comments

#61 - Support .where(sql())

Pull Request - State: closed - Opened by prust about 10 years ago - 1 comment

#60 - Allow where to accept sql()-escaped code or subquery

Issue - State: closed - Opened by sandfox about 10 years ago - 1 comment

#59 - removed the function call

Pull Request - State: closed - Opened by cultofmetatron about 10 years ago - 1 comment

#58 - Added "LIMIT" support

Pull Request - State: closed - Opened by CodeTrol over 10 years ago - 3 comments

#57 - Extension helper with fixed clauses shielding

Pull Request - State: closed - Opened by Suor over 10 years ago - 3 comments

#56 - Add _extension() helper

Pull Request - State: closed - Opened by prust over 10 years ago - 2 comments

#55 - Add _extension() helper

Pull Request - State: closed - Opened by Suor over 10 years ago - 4 comments

#54 - Fix inherits() for older browsers

Pull Request - State: closed - Opened by Suor over 10 years ago - 1 comment

#53 - Dirty extensions

Issue - State: closed - Opened by Suor over 10 years ago - 9 comments

#52 - Support INSERT without columns

Pull Request - State: closed - Opened by Suor over 10 years ago - 5 comments

#51 - Remove unneeded null passing when inserting without explicit values

Pull Request - State: closed - Opened by Suor over 10 years ago - 1 comment

#50 - Alternative complex alias hook

Pull Request - State: closed - Opened by prust over 10 years ago - 4 comments

#49 - Add a hook to allow complex aliases

Pull Request - State: closed - Opened by Suor over 10 years ago - 1 comment

#48 - Do not stringify everything in expandAlias()

Pull Request - State: closed - Opened by Suor over 10 years ago - 2 comments

#47 - Pass ownership of sql-bricks-postgres

Issue - State: closed - Opened by Suor over 10 years ago - 2 comments

#46 - Fix parameterized things in FROM clause

Pull Request - State: closed - Opened by Suor over 10 years ago - 1 comment

#45 - expandAlias() triggers subquery stringification

Issue - State: closed - Opened by Suor over 10 years ago - 2 comments

#44 - Data Type Casting?

Issue - State: closed - Opened by rickbergfalk over 10 years ago - 1 comment

#43 - Dialect Extension mechanism

Pull Request - State: closed - Opened by prust over 10 years ago - 3 comments

#42 - Add "select * from (values ...)"

Issue - State: closed - Opened by Suor over 10 years ago - 4 comments

#39 - allow objects in `.orderBy`

Issue - State: closed - Opened by Janpot over 10 years ago - 3 comments

#37 - Case converting support on column and table names.

Issue - State: closed - Opened by ghost over 10 years ago - 2 comments

#36 - Move postgres-specific & sqlite-specific clauses to separate extension files

Issue - State: closed - Opened by prust over 10 years ago - 8 comments

#29 - Add asc/desc keywords to API

Issue - State: closed - Opened by prust over 10 years ago - 2 comments

GitHub / CSNW/sql-bricks issues and pull requests