How to make a request depending on the current language?

Question

SQL

Site on wp, multilingual. Polylang plugin
such sql query returns all posts in both English and Russian.

SELECT * FROM $wpdb->posts WHERE post_type = 'post'

How to return posts only in Russian or only in English?

More or less like this:

SELECT * FROM $wpdb->posts WHERE post_type = 'post' AND locale=ru

???

Answer 1

A language in polylang is a custom taxonomy. Look in a DB as it stores the data.
An example of an array when using a class for database queries:

$args = array(
  'category'  => pll_get_term(34)
);

Answer 2

You can get the current localization with get_locale(). Returns the string en_US, ru_RU, etc.