UsefulRegexes.txt

From camelcase to db column  name

find
  /([a-z_]*)([A-Z])(.*?$)/

replace with 
  /\1_\l\2\3/

repeatedly


from db column name to camelcase (table name should be only lowercase and underscores)


find
  /([a-z]*)_([a-z])/

replace with
  /\1\u\2/



find all double quotes out of square brackets (to convert them to single quotes)

find 
  (?<!\])"(?!\[) 
replace
  '

sample case: "["testing","of","regex"]" -> "['testing','of','regex']"