RethinkDB case insensitive query in python

Connect to the database:

import rethinkdb as r
r.connect("127.0.0.1", 28015).repl()
db = r.db("search")

Filter using match:

table.filter(r.row["Url"].match("(?i).*\.PDF$")).count().run()

Note that unlike SQL, the column headers are case sensitive. It appears that the regular expression must match the entire string.