expand query params in jsonified apache log file

gistfile1.txt

#!/bin/sh
#
# this scripts expands the query string for jsonified apache logs.
# In order to work, it expects an apache log as produced by:
#
# LogFormat "{\"time\":\"%t\", \"remoteIP\":\"%a\", \"forwardedFor\":\"%{X-Forwarded-For}i\", \"host\":\"%V\", \"pid\":\"%P\", \"request\":\"%U\", \"query\":\"%q\", \"method\":\"%m\", \"status\":\"%>s\", \"userAgent\":\"%{User-Agent}i\", \"referer\":\"%{Referer}i\", \"requestTime\":\"%D\"}" jsonlog

sed -r 's/"query":"\?([^"]+)"/"query":{ \&\1 }/' |
sed -r '
  /"query":\{/, /\}/ {
      s/\&([^=]+)=([^\& ]+)/"\1":"\2"/g
      s/""/","/g
    }
  '