What are the limits of identify? Can we use it when crafting? Can we use it to translate tablets?

Yes. And Yes.

I wouldn't speak on its limit as it is something we usually best leave at each DM's discretion in whatever event they are running.