Full replacement of table lamp socket with edge switch?

Use case requirement:

For table lamp - natively HA integrated WiFi switch FULLY REPLACING a table lamp light socket that can -

a. turn the light on or off remotely,
b. turn the light on or off at the socket switch itself independent of the remote switch status edge switch,
c. able to use LED bulb
d. does not require a ground or neutral (regular old wire to the lamp.

This should not be hard - there is always power to the wire. A specalized relay can be connected directly to even an old lamp socket on the same lamp if need be - or at the plug :slight_smile