How to write data into flat file from SQL server using powershell

See more:

PowerShell

scripting

We have 2 tables Tables : ApplePhone and AppleGear
Table Structure:ApplePhone
Id Phone
1 6s
2 7s

Table Structure:AppleGear
Id Gear
1 ear
2 watch

Now we need to write the above table data into flat files with | delimiter.
2 O/p File should be:
ApplePhone.dat
Id|Phone
1|6s
2|7s

AppleGear.dat
Id|Gear
1|ear
2|watch

Please help us with this if anyone has already has a code snippet.

What I have tried:

So far came up with this code:

$SQLServer = 'myServer';
$Database = 'AppleDB';
$SqlQuery = @'
Select Id,Phone FROM [AppleDB].[dbo].[ApplePhone]
'@;

Don't know how to proceed now. Newbie to this scripting world.