build_query_regex: Build a Regex Query
In patelm9/pg13: pg13 Package

Build a query that searches for a regular expression.

build_query_regex(
  fields = "*",
  distinct = FALSE,
  schema,
  table,
  where_regex_field,
  regex,
  invert = FALSE,
  case_insensitive = TRUE,
  limit,
  random
)

`fields`	Fields selected for. Defaults to "*".
`distinct`	If TRUE, the distinct row count will be returned.
`schema`	The target schema for the operation.
`table`	Target table for the operation.
`case_insensitive`	If TRUE, both sides of the query are converted to lowercase.
`limit`	(Optional) Integer of the row limit. Takes precedence over `random` if both arguments are provided.
`random`	(Optional) Integer of the random number of rows to return. Is preceded by `limit` if both `limit` and `random` are provided.