pkoppstein

Google Spreadsheets uses RE2, so it's easy to verify that =REGEXREPLACE("ab cd", "\b", "X") produces XabX XcdX In other words, RE2 as currently used by Google Spreadsheets works correctly. So...

@NickCrews - You can use the 'g' option for global replace: ``` D select regexp_replace('ab cd', '\b', 'X', 'g'); ┌─────────────────────────────────────────┐ │ regexp_replace('ab cd', '\b', 'X', 'g') │ │ varchar │...

There has historically been strong support for a "shell-out" feature for jq, but it hasn't happened for a variety of reasons, one of which is security. In particular, see PR...

> As of currently, there is no sandbox. I can't depend on an unmerged PR… as it's not merged yet. Yes, there is a bit of a chicken-and-egg problem, but...

@cosmictoast - I'm sorry my comments came across as condescending and pushy. Since you indicated that your (mis)interpretation was partly based on my not being a maintainer, forgive me for...

> I took a look at outputting a stream ... Thanks. Just to be clear, I don't think that not having the option to stream the output will or should...

> I could probably take a look at adding a PRNG (namely PCG32) in a separate PR if there's interest. There is and has been strong interest in this. See...

> The main challenge (as mentioned) would be outputting a stream… If you use `input` as your model, you won’t have that problem. (Notice how `inputs` is defined in builtin.jq.)

Adding a stream-oriented `add` is long-overdue, so my hope is that its introduction will not be delayed by potentially contentious issues. Adding stream-oriented versions of min, max, min_by, and max_by...

Also the parens previously required for `(foreach ...) as $x` and `(reduce ... ) as $x` can now be dropped! For example: ./jq -n 'reduce range(0;1) as $x([]; .+[$x]) as...