With current "Copy as" you have 2 options:
have a look at
-Copy as "WHERE" - if you have marked columns with primary key (or columns that identify uniquely the records), you will get a WHERE statement, that you simply add to your SELECT statement and execute it again, ang get filtered results set (ok - with all columns)
-Copy as "SELECT" - it copies all seleced data in "SELECT from VALUES" form, so you can execute generated statement everywhere and get same dataset. (try it !). Current limitation - everything is scripted as strings. In next releases this will be improved.