proc search*(query: string, page: int): seq[Torrent] =
  echo query
  let perPage = 5
  let skip = page * perPage
  let db = open("torrentinim-data.db", "", "", "")
  let torrents = db.getAllRows(sql"SELECT name, canonical_url, uploaded_at FROM torrents WHERE name LIKE '%?%'", query)

  for row in torrents:
    result.add(Torrent(name: row[0], canonical_url: row[1], uploaded_at: parse(row[2], "yyyy-MM-dd'T'HH:mm:sszzz"))) #2019-12-23T23:15:41-05:00
  db.close()

#========

An error has occured in one of your routes.
Detail: /Users/sergiotapia/.nimble/pkgs/httpbeast-0.2.2/httpbeast.nim(287) eventLoop
/Users/sergiotapia/.nimble/pkgs/httpbeast-0.2.2/httpbeast.nim(219) processEvents
/Users/sergiotapia/.nimble/pkgs/jester-0.4.3/jester.nim(485) :anonymous
/Users/sergiotapia/.nimble/pkgs/jester-0.4.3/jester.nim(386) handleRequest
/Users/sergiotapia/.choosenim/toolchains/nim-1.0.6/lib/pure/asyncmacro.nim(313) dispatch
/Users/sergiotapia/.choosenim/toolchains/nim-1.0.6/lib/pure/asyncmacro.nim(34) dispatchNimAsyncContinue
/Users/sergiotapia/.nimble/pkgs/jester-0.4.3/jester.nim(285) dispatchIter
/Users/sergiotapia/.choosenim/toolchains/nim-1.0.6/lib/pure/asyncmacro.nim(313) match
/Users/sergiotapia/.choosenim/toolchains/nim-1.0.6/lib/pure/asyncmacro.nim(34) matchNimAsyncContinue
/Users/sergiotapia/Work/torrentinim/src/torrentinim.nim(22) matchIter
/Users/sergiotapia/Work/torrentinim/src/database.nim(57) search
/Users/sergiotapia/.choosenim/toolchains/nim-1.0.6/lib/impure/db_sqlite.nim(256) getAllRows
/Users/sergiotapia/.choosenim/toolchains/nim-1.0.6/lib/impure/db_sqlite.nim(216) setupQuery
/Users/sergiotapia/.choosenim/toolchains/nim-1.0.6/lib/impure/db_sqlite.nim(144) dbError
[[reraised from:
/Users/sergiotapia/.nimble/pkgs/httpbeast-0.2.2/httpbeast.nim(287) eventLoop
/Users/sergiotapia/.nimble/pkgs/httpbeast-0.2.2/httpbeast.nim(219) processEvents
/Users/sergiotapia/.nimble/pkgs/jester-0.4.3/jester.nim(485) :anonymous
/Users/sergiotapia/.nimble/pkgs/jester-0.4.3/jester.nim(386) handleRequest
/Users/sergiotapia/.choosenim/toolchains/nim-1.0.6/lib/pure/asyncmacro.nim(313) dispatch
/Users/sergiotapia/.choosenim/toolchains/nim-1.0.6/lib/pure/asyncmacro.nim(37) dispatchNimAsyncContinue
/Users/sergiotapia/.nimble/pkgs/jester-0.4.3/jester.nim(285) dispatchIter
/Users/sergiotapia/.choosenim/toolchains/nim-1.0.6/lib/pure/asyncfutures.nim(383) read
]]
[[reraised from:
/Users/sergiotapia/.nimble/pkgs/httpbeast-0.2.2/httpbeast.nim(287) eventLoop
/Users/sergiotapia/.nimble/pkgs/httpbeast-0.2.2/httpbeast.nim(219) processEvents
/Users/sergiotapia/.nimble/pkgs/jester-0.4.3/jester.nim(485) :anonymous
/Users/sergiotapia/.nimble/pkgs/jester-0.4.3/jester.nim(386) handleRequest
/Users/sergiotapia/.choosenim/toolchains/nim-1.0.6/lib/pure/asyncmacro.nim(313) handleRequestSlow
/Users/sergiotapia/.choosenim/toolchains/nim-1.0.6/lib/pure/asyncmacro.nim(37) handleRequestSlowNimAsyncContinue
/Users/sergiotapia/.nimble/pkgs/jester-0.4.3/jester.nim(336) handleRequestSlowIter
/Users/sergiotapia/.choosenim/toolchains/nim-1.0.6/lib/pure/asyncfutures.nim(383) read
]]
near "the": syntax error
Async traceback:
/Users/sergiotapia/.nimble/pkgs/httpbeast-0.2.2/httpbeast.nim(287) eventLoop
/Users/sergiotapia/.nimble/pkgs/httpbeast-0.2.2/httpbeast.nim(219) processEvents
/Users/sergiotapia/.nimble/pkgs/jester-0.4.3/jester.nim(485) :anonymous
/Users/sergiotapia/.nimble/pkgs/jester-0.4.3/jester.nim(386) handleRequest
/Users/sergiotapia/.choosenim/toolchains/nim-1.0.6/lib/pure/asyncmacro.nim(313) dispatch
/Users/sergiotapia/.choosenim/toolchains/nim-1.0.6/lib/pure/asyncmacro.nim(34) dispatchNimAsyncContinue
/Users/sergiotapia/.nimble/pkgs/jester-0.4.3/jester.nim(285) dispatchIter
/Users/sergiotapia/.choosenim/toolchains/nim-1.0.6/lib/pure/asyncmacro.nim(313) match
/Users/sergiotapia/.choosenim/toolchains/nim-1.0.6/lib/pure/asyncmacro.nim(34) matchNimAsyncContinue
/Users/sergiotapia/Work/torrentinim/src/torrentinim.nim(22) matchIter
/Users/sergiotapia/Work/torrentinim/src/database.nim(57) search
/Users/sergiotapia/.choosenim/toolchains/nim-1.0.6/lib/impure/db_sqlite.nim(256) getAllRows
/Users/sergiotapia/.choosenim/toolchains/nim-1.0.6/lib/impure/db_sqlite.nim(216) setupQuery
/Users/sergiotapia/.choosenim/toolchains/nim-1.0.6/lib/impure/db_sqlite.nim(144) dbError
#[
/Users/sergiotapia/.nimble/pkgs/httpbeast-0.2.2/httpbeast.nim(287) eventLoop
/Users/sergiotapia/.nimble/pkgs/httpbeast-0.2.2/httpbeast.nim(219) processEvents
/Users/sergiotapia/.nimble/pkgs/jester-0.4.3/jester.nim(485) :anonymous
/Users/sergiotapia/.nimble/pkgs/jester-0.4.3/jester.nim(386) handleRequest
/Users/sergiotapia/.choosenim/toolchains/nim-1.0.6/lib/pure/asyncmacro.nim(313) dispatch
/Users/sergiotapia/.choosenim/toolchains/nim-1.0.6/lib/pure/asyncmacro.nim(37) dispatchNimAsyncContinue
/Users/sergiotapia/.nimble/pkgs/jester-0.4.3/jester.nim(285) dispatchIter
/Users/sergiotapia/.choosenim/toolchains/nim-1.0.6/lib/pure/asyncfutures.nim(383) read
]#
Exception message: near "the": syntax error
Exception type: