I don't think there's a restriction on our side. Timestamps are just used internally in the query for filtering, but aren't passed back to us in the final result. So as long as the db engine supports higher precision I think that should work.
The one exception might be BigQuery, since we cast all timestamps to the DateTime type before using them.