You just need to quote your identifiers with double quotes, e.g.:

    SELECT * FROM "MyTable"

You can even use reserved SQL keywords in table/column names as long as they are double-quoted.