In ArcGIS Pro GUI, after selecting some rows/features I can right-click the layer name in the Contents -> Selection -> Make Layer from Selected Features.
How can I achieve this using ArcPy? With the result added to the active map.
Ohh, re-reading what was said in this post, I understand now that all I need to do is apply by selection directly when using MakeFeatureLayer using the "where_clause" parameter. So rather than making the selection first and then calling MakeFeatureLayer, I can skip the SelectLayerByAttribute and instead put that selection criteria directly into the where_clause parameter of MakeFeatureLayer. This works for my use case!
check your geoprocessing options in the Project backstage to ensure that results are added to the active map.
Yep that's already ticked on