feat: include the 'client' field in the querying and prioritize FTP client

[luabida]

No description provided.

[codecov-commenter]

⚠️ Please install the to ensure uploads and comments are reliably processed by Codecov.

Codecov Report

❌ Patch coverage is 51.51515% with 16 lines in your changes missing coverage. Please review.
⚠️ Please upload report for BASE (main@6aca1bd). Learn more about missing BASE report.

Files with missing lines	Patch %	Lines
pysus/api/ducklake/client.py	44.44%	10 Missing ⚠️
pysus/api/_impl/databases.py	0.00%	6 Missing ⚠️
❗ Your organization needs to install the Codecov GitHub app to enable full functionality.

Additional details and impacted files

@@           Coverage Diff           @@
##             main     #273   +/-   ##
=======================================
  Coverage        ?   76.07%           
=======================================
  Files           ?       34           
  Lines           ?     3624           
  Branches        ?        0           
=======================================
  Hits            ?     2757           
  Misses          ?      867           
  Partials        ?        0           

☔ View full report in Codecov by Sentry.
📢 Have feedback on the report? Share it here.

🚀 New features to boost your workflow:

• ❄️ Test Analytics: Detect flaky tests, report on failures, and find test suite problems.

[github-actions]

🎉 This PR is included in version 2.1.0 🎉

The release is available on:

• 2.1.0
• GitHub release

Your semantic-release bot 📦🚀