Yes it just has to be designed for it. Two flashings are used to flash tile. The first flashing goes between the OSB and the felt. This protects the penetration from water entering from other areas. The top flashing goes below the upper row of tiles an on top of the lower row of tiles.
Solarise Tube Skylights