def parse(typebychar, connection, text, *args, **kvargs):
  i = iter(text)
  index = 0
  result = ''
  try:
    while True:
      try: c = next(i)
      except StopIteration: break
      if c == '%':
        c = next(i)
        if c == '(':
          field = ''
          while True:
            c = next(i)
            if c == ')': break
            field += c
          c = next(i)
          result += typebychar[c].to_db(connection, kvargs[field])
        elif c == '%':
          result += '%'
        else:
          result += typebychar[c].to_db(connection, args[index])
          index += 1
      else:
        result += c
  except StopIteration:
    raise Exception('unexpeted end of sql template')
  return result